Hi,
I have two tables:
tblProperty and tblValuations
I want to compare the PropNumr and Streetname fields in tbl Property to the the equivalent fields in tblValuations. If there is a match, I want to transport / copy across the ValuerID field in tblValuations to tblProperty.
Any ideas?