Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Record deletes but one in a related form
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.