QB has location # 123
Status choices are a drop down box: completed, pending
I will have another choice added in the drop down box called completed V10
I want the loc# in table 2 to match loc# in QB and update the status field only to completed V10 . Any loc# in table 2 not found in QB, have a drop out report so I know which ones were not updated.