Delete record in 2 tables

[mwheads]

Hi All

I would like a button to run code to prompt the user (InputBox) for a reference and then delete the record in the first table and then all records with that reference in the 2nd table.

Field - SupplierReference
tblTranactions - no duplicates (so only one to delete)
tblLedgerPosting - duplicates

I have not come right so far, any suggestions.

Regards,

 

[afryer]

Hi,

By far the easiest way to do do this is to set up a relationship between the two key fields in your table. Link from the table where the key is a primary key (i.e only one entry) and drag it across to the same field on the other table. When the relationship window comes up it will say it is a 1 to many relationship. Ensure the cascase delete is selected and when you delete a record from your primary table all of the other records with that ID will be deleted as well.

Hope this helps


Andrew

 

[mwheads]

Hi Afryer

Thanks I will do that, some things are simpler than we think