I'm trying to merge information from two separate tables in different applications. the locations table in the first application (App1) has a list of students identified by student ID with the classroom, program, and grade band each student is projected into (3 source fields). The key field for the locations table (source table) must be record id for various other relationships within App1. App2 has a table called student demographics (master table) that also has the key field as record ID which also must remain. We want to pull in information from the 3 source fields from the Locations table into the student demographics table. Both tables have another unique field- Student ID. If I were in excel I would set Student ID as the lookup value. However, when i go to set up the merge, I am only given the option to merge based on the record ID (key field) and thus cannot merge based on Student ID. How do I merge on a unique field in both tables that isn't the key field? We are hoping to have the information populate automatically and will set it to import everyday or every week. thanks so much!