need parameter delete and a update query (97 sr2)

Topic

New Reply

I need a parameter query to delete a customer number simultaneously in the customer file, the order number file and the sales item file. I need some direction. I also need nearly the same parameter query to attribute a new customer number in all the same files.

Reply | Quote

Replies

Well this is a new one for me… I know I don’t have half the experience of many people here… but I’ve never seen a query that updated more than one table at once…. Unless the job is done with relationships among the tables??

Sounds to me like you need to create some relationships with referential integrity enforced….

Also… the delete query you were talking about…. does that mean you just want the customer number to be deleted and the field left blank, but the records to remain?…. or do you want any and all records in all three tables for that customer number deleted simultaneously?

Reply | Quote

To ad to Alexya’s comments and questions, if you are simply trying to replace a given customer number that exists in one or more records in several tables, then enforcing referential integrity and turning on cascading updates will do the job for you – all you have to do change the customer number in the master record and all the others will be changed.

On the other hand, if you are truely wanting to just blank out the customer number in several records, and that is the number that joins the records, then I believe Access97 will tell you that is not an updateable query. The same is true for update queries given that the customer number is the key that links tables together.

Give us a bit more detail and perhaps we can suggest other solutions.

Reply | Quote