Multi Table Record deletion

[ZeoGel]

I have a form with 2 subforms the Main form creates a record number that is put in to a table then in subform that record number is put into another table and then if i click on a tab to another subform that creates another record in yet another table. how can i create a One button on the main form that would delete those records on 3 different tables with a common number?


Thank You

 

[Krystoff]

ZeoGel,

Do you have relationships built between them with referential integrity enforced?

If you don't know how to do that, goto:
Tools > Relationships

If you have referential integrity forced between the tables, you can not have a record in the many table unless there is a record in the one table. Also, when you delete a record in the one table, it deletes all instances of that in the many table as well.

HTH

Chris