Deletion

[Vic_Orr]

Hey

I have a database that holds share holders. When they die they are to be removed and appended to another table. There is around 5 tables for each member e.g shares table, certificate table. There is only one primary key due on the holders details table. Each has there own unique holder code.

I was wondering if it is possible to delete from each of these 5 tables in one go or am i going to need to have 5 seperate append and delete queries?

Thanking you in advance


P.s

I am an amateur user in access so i might not be to clear on how i explained it

 

[neileg]

Look for help on cascading deletes.

 

[Vic_Orr]

Would that work since i only have one primary key?? These tables are not linked because i couldn't get it to work linking them

 

[neileg]

Ah, right. So how can you tell which entries in each table tie up with each other?

 

[Vic_Orr]

With a unique holder code. This appears in every table but it isn't necessaryily used once in each table

 

[neileg]

So you have this code in the holder details table, and you use it whenever the same person has details in the other tables? In database parlance, this is a primary key in the main table and a foreign key in the other tables.

So....

Look for help on cascading deletes!

 

[Vic_Orr]

Cheers