I have a Customers Form linked to a Service Record Form. The Customer Form's record source is a Query (Made from Billing Address (Primary Key = BillingID) and Site Table (Foreign Key = BillingID). The Service Form is linked to Customer Form (Opens by Command Button Wizard "Open Form") by the SiteID in the Customer Form and the SiteID (foreign) in the Service Form. In my tables I do have Cascade Delete in my actual tables. When I hit Delete Record (on my Customer Form) I DO get the record in the Customer Form and Service Form deleted. But when I check the underlying tables there is STILL a Billing record in the Billing Table.
Please help. Thanks.