Qrew Legend... so to clarify, the Key field of your Persons table is just [Record ID#] and you need to somehow coax that number down to your 45,000 record import table.
Could you change the Key field of the Person table to be that Employee ID#?
If not, I have had some success in the past with making a new connected Sync table which duplicates certain fields in your Persons table, and then changing the Key field of the Connected Sync table to be the Unique Employee ID#. Then Persons "mirror" table would be the Parent to the 45,000 record table and you would just lookup the [Record ID#] of the Persons Table down to the 45,000 record table.
