Lookup a field other than primary key

I have two tables I am working with. One has student information, and the other has their addresses (Since a student may have multiple addresses for various reasons). I want to be able to link the address to the student in question.

This is no problem, other than the fact that our primary key (for import/export) purposes is the student’s ID number. What I am looking for is the ability to lookup by the student’s name (Which is a field in the student table) so that instead of typing in student ID, you can type in their name and get results.

How can I go about doing this? I feel like I am missing something obvious :sweat_smile:

Hi @Tony_Sullivan

You can use a concatenate() formula in your primary field to add the student’s name (and other data if you want). That way, you’ll be able to use that when linking records.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.