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!
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!