Re: Deleting tables in an Access database
Ok, here's the deal...
I have a small site and on the admin bit one of the options is to delete a member of staff from the system.
There are two tables on the database that would then need records deleted from it.
The tblEmployees - coz that holds the users login name, password etc
The tblWork - coz that holds 52 records each for a week in the year relating to that member of staff.
Whenever the admin person deletes a member of staff, the site has to delete the one record from the first table and the relating 52 records from the second table.
During the creation of these records, I had to use sessions to pass identifiers through the create the 52 records in the other table, that's where I was going in the previous post. I just thought I'd have to do the same that's all.
I shall try what you've said though anyway coz that looks like the best option.