delete record

[rashidzaib]

hy bro and sis
i hope all r fine
i have a mater/detail access form and when i press delete button it is just only deleting master record not detail record. when i am viewing the record it show both mater and detail record. i have define relationship just only on form not table. any solution should realy be appriciated.
thank u in advance.
take care
bye

 

[The_Doc_Man]

If you meant to delete detail records when you deleted the master materials record, you should have created a formal relationship and turned on Referential Integrity, then enabled CASCADE DELETE. That is the "correct" way within Access to get the behavior you are describing.