I have one table called TableA with two fields for Partnumber and Serialnumber. I want to add another field called repairID and fill it as follows:
In a second table called TableB, there is a repairID as the primary key and Partnumber and SerialNumber fields. these two fields, when paired together are unique in this table. I want to fill TableA.repairID with TableB.repairID by matching the parnumber and serialnumber from the two tables. Does anybody know how to do this? Thanks.
In a second table called TableB, there is a repairID as the primary key and Partnumber and SerialNumber fields. these two fields, when paired together are unique in this table. I want to fill TableA.repairID with TableB.repairID by matching the parnumber and serialnumber from the two tables. Does anybody know how to do this? Thanks.