I'm building an administration system in Classic ASP, and that include profiles.
Now I have a lot of profiles, and some IDs are registered in several tables.
If I delete a profile on the member's list (table1), I will do like this:
DeleteProfileSQL = "DELETE FROM [table1] WHERE [id] = " & Request.QueryString("id")
...and that profile will be deleted in the table1!
But the ID of that person may be registered in other tables as well.
How do I make sure that when the record is deleted in table1, following will also happen:
In table2: Only update the existing record (remove the profile's ID)
In table3: Find all the records with the deleted profile's ID and delete the rows containing the profiles ID.
It will also occur that the deleted ID in table1 doesn't exist in any other tables.
Thanks in advance!!