Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I update more than one field with the same parameter?

Status
Not open for further replies.

lbodie

IS-IT--Management
Sep 4, 2001
4
US
I want to create a query that will update a few fields with the same user-entered parameter. We freqently change our customer numbers and I need a way to update 3 or 4 tables at the same time when the user enters a number. For example: custmast.custnum = 123456, actsum.custnum = 123456
custnum changes from 123456 to 789012. I want a query that will prompt the user for old custnum and new custnum and update BOTH tables. Any ideas?

Thanks in advance!
 
If u used referential integrity with cascade option turned on... then you would update the customer number in one location and all other tables should be updated automatically... Steve Medvid
"IT Consultant & Web Master"
 
I will check into this. I have never used it or heard of it.

Thanks,
 
Open ur database, go to Tools Menu then Relationships Menu option... Steve Medvid
"IT Consultant & Web Master"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top