Hi everyone. I'm pretty new to access and I was tasked with making a query that updates a table in access. So basically I have 3 tables, and I have to match a field in the first table to a field in the second table, then match 2 other fields for those records to a third table and update the first with that value. My head is spinning from this and I'm confusing myself!!
So this is what I need to do:
Take field Customer_ID from tblCustomer
Match Customer_ID value to field SNumber in table tblConvert
There will be duplicate values for SNumber in tblConvert, but there are other fields for each record that are unique, Property and CustTag
Take the records that matched SNumber and use the fields Property and CustTag for those records and look Property and CustTag up in a table called tblID and return the field called SCODE that matched Property and CustTag and then update LastName in tblCustomer with the SCODE value
Is an update query even the way to go? tblConvert and tblID are linked tables that reside on a SQL server that cannot be modified, so I was just guessing that this was the best way to do it? Is this even possible or should I just take a xanax and go home?