Hello

Can you tell me the best way to delete a record that is related to another table. For instance, I have a customer and invoice table (Customer ID is the Primary Key in Customer and the Foreign key in invoice).

I wish to delete the Customer in the Customer table but not all of its related invoices in the Invoice table.

I am using VB6 front end with an Access database.

Thanks