Query button

[Dega]

Hi,

I attempted to use the button option in design view to delete the current record that is the present view on the form.

Let's say tblCustomerID = 90 is the present view on the form. That is the record I wish to delete as well as all other information in tblBookings and tblGroup which have the customerID.

What is happening is that the records in tblGroup are being deleted and nothing else.

This standard form is based upon tblCustomers which includes one row from tblGroup.GroupName. (tblGroup has GroupName, GroupID, and CustomerID)

tblBookings is a subform dragged from the table workspace.



Can someone tell me if I need to create a SQL query instead of a macro, and how do I associate the record to be deleted with the present form view?

Thanks

[Rainlover]

In your Relationships you need to Enforce Referential Integrity and tick Cascade Deletes.

But I do advise against this as it is too easy to delete by mistake.

[Dega]

Thanks for the reply,

The one-to-many relationships are there along with the Enforce Referential Integrity and Cascade Update Related Fields and Deletes. Don't know why it does not work and why it points to the tblGroups.

Would subform organization point the focus of the update/delete actions to this table?

It seems most are against deleting records so can you suggest how I would change the customer record to active/cancelled status which would refect those records (Cascade) in other tables.

Can I use a option list that would show "active" with value of 1 and another "cancelled" with a value of 0.

Something like that.

Thanks

[Rainlover]

Without seeing your actual Database I can't say for sure why your deletes are not working properly. I do feel that it is a problem with the relationships.

<< Can I use a option list that would show "active" with value of 1 and another "cancelled" with a value of 0. >>

Yes you can do that but make sure the default value is True.