S
Steve
I am trying to run a delete query where I have two tables, one to many
relationship, and I would like to delete all of the records in both tables
where the criteria field is in my "one" of the one to many relationship.
For example I am tracking invoices with an invoice header table, which has
invoice#, customer#, date and time and I have an invoice detail table with
my invoice#, product#, quantity and price. I am joined on the invoice# but
I want to delete all records from both tables where the customer# = 123.
Any ideas?
Thanks,
Steve
relationship, and I would like to delete all of the records in both tables
where the criteria field is in my "one" of the one to many relationship.
For example I am tracking invoices with an invoice header table, which has
invoice#, customer#, date and time and I have an invoice detail table with
my invoice#, product#, quantity and price. I am joined on the invoice# but
I want to delete all records from both tables where the customer# = 123.
Any ideas?
Thanks,
Steve