Hi
I had a form with contain a sub-form. It is linked by 2 individual tables with related by 1 to many (but not in the query) & having a same field e.g. [Name]. (This relation is created when I use the sub-form wizard.)
Q1.
How can I make a bottom so that when I delete a record, both related main & sub-form record will be deleted too? I do not pull the record from its query but from the 2 tables. The reason for this is I may delete the record from table2 & I can not do so if it is pulled from the query.
Q2
I wish both deleted record to be keep in “another table’. How can I do so?
Thanks
jiajian
I had a form with contain a sub-form. It is linked by 2 individual tables with related by 1 to many (but not in the query) & having a same field e.g. [Name]. (This relation is created when I use the sub-form wizard.)
Q1.
How can I make a bottom so that when I delete a record, both related main & sub-form record will be deleted too? I do not pull the record from its query but from the 2 tables. The reason for this is I may delete the record from table2 & I can not do so if it is pulled from the query.
Q2
I wish both deleted record to be keep in “another table’. How can I do so?
Thanks
jiajian