Concatenated field values in foreign keys

When creating foreign key references to other tables, it would be terrific if multiple fields related to the same ID could be concatenated.  For example, I have a table that contains a list of individuals detailed by first name, surname and year group.  Listing any one of these fields may not be sufficient - but 'year_group + first_name + surname' is a much more powerful combination for selecting, filtering and listing.

Thanks in advance for any consideration.

+ one

+ one

This is a great feature