I've searched and can't find what I need in a similar thread. Here is my update statements in SQL:
update
FieldTicketHeader set sonumber=1001435 where fieldticketnumber in('MAR102208','MAR102209','MAR102210')
update
FieldTicketInvoice set sonumber=1001435 where fieldticketnumber in('MAR102208','MAR102209','MAR102210')
update
PayrollDetailTable set sonumber=1001435 where fieldticketnumber in('MAR102208','MAR102209','MAR102210')
I am trying to duplicate this on one form in Access. I want the end user to be able to open this form and enter the old or original SO Number, the new or SO Number the field tickets are moved to and then the tickets (more than one ticket might be needed to update). I am not sure how this can be done since there are 3 tables that need to be updated. Can anyone help me with this as I am not sure if I need some elaborate query to bound the form? Maybe I am thinking in the wrong direction. Help. Thanks.