Multiple subforms

[JaredNJames]

Hi, i have an invoicing form which has two seperate subforms from seperate tables.

one from tbl_service details and one from tbl_invoice details.

tbl_invoice details is linked to the invoicing table and when delete is pressed, it updates both tables a appropriate.
but because i cannot put tbl_service details as "enfore referential integrity", along with tbl_invoice details it doesnt update that one as well.

any ideas how i could get them both to clear the data from their tables.

jjames

 

[Banana]

but because i cannot put tbl_service details as "enfore referential integrity", along with tbl_invoice details it doesnt update that one as well.

If you're going to be deleting records, I'd definitely want to enforce referential integrity. Why cannot you? What happens when you try to?