Lookup a field other than primary key

Topic Labels: Base design
846 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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 :grinning_face_with_sweat:

1 Reply 1

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.