1 of 1 people found this helpful
It's not foolproof, because names are not always unique. But I often create a temporary relationship between the two tables, matching the fields you deem necessary.
Then in the table with the missing data, you can use a Replace in the field to "set" the related field info based on the temporary relationship.
If you need to Lookup this information often, you'd do we'll to also have an ID field (auto-enter) that would be your real relationship.
-- sent from my iPhone4 --