thank you all for helping me ..
To explain what I did was I emptied all the records from the tables related to the main table
and when I delete the master record, All related records is deleted ..
thanks again
I tried to set a cascade in relationships but only one relation done..
the other relationships (no relation appear or error message appear as file attached )
I checked the records and all records are linked
Hi ,
I apologize for my English language , (Arabic is my mother tongue)
Now.. I am new in programming with MS access..
I designed from added records in many tables with multiple sub-forms, all of them is linked with master ID in main table..
The problem is :
When the user deletes the master...