Hi,
I currently have 2 SQL tables linked in Access 2K. It is a one-many relationship, a main company details table linked to a multiple contacts table.
Have created a form that looks at both tables and can alter details and delete individual contacts.
However, now I'm trying to implement a function that will delete a company AND its associated contacts at the same time (with the use of a command button). I can delete the company and the contacts will obviously no longer appear on the form but they will be ophaned in the contacts table which is not ideal.
Anyone have any ideas how I can do this - any help appreciated.
cheers,
Alex

I currently have 2 SQL tables linked in Access 2K. It is a one-many relationship, a main company details table linked to a multiple contacts table.
Have created a form that looks at both tables and can alter details and delete individual contacts.
However, now I'm trying to implement a function that will delete a company AND its associated contacts at the same time (with the use of a command button). I can delete the company and the contacts will obviously no longer appear on the form but they will be ophaned in the contacts table which is not ideal.
Anyone have any ideas how I can do this - any help appreciated.
cheers,
Alex
