Record deletes but one in a related form - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

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.

Comments

  • gigsvoogigsvoo Posts: 328Member
    Normally what i do was, i delete one record from one table with one SQL statement, after i do another delete to another table using another SQL statement.

    Maybe u can do it manually?

    : 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.
    :

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


Sign In or Register to comment.