Can't delete records

[joe1987]

Hi,
I have my subforms joined in to tabbed form. Can I somehow make that 'delete' button will delete all records in the database related with the same ID? Other problem is - when I press delete record it doesn't allow me to delete, cause there're relationships between different tables.


DB sample below:
http://www.2shared.com/file/gizRTHdB..._version_.html

[pbaldy]

I haven't looked at the sample, as I don't download from unknown websites. Offhand, two thoughts/methods. In your relationships, you can use Cascade Delete in Referential Integrity. That would delete all sub records when the main record is deleted. You can also use code to grab the ID and then run delete queries on each sub table and then on the main table using that ID as a criteria.