Orphaned links
Bit of advice needed from Forum users!
I am creating a database - it has a couple of tables, which are linked. It's on a writer and article basis - I don't want to delete any writers that have articles in the database.
I was thinking of putting a show recordset 'if empty' and 'if not empty' on the delete page of the writer - so if there are any articles with the writer's ID in you will see either the delete form (if empty) or a message to say "There are articles by this writer in the database, do you still want to delete or would you like to see the articles?" (if not empty)
Is that the kind of thing you'd do?
Many thanks
Vanrooj