I’m creating a research repository and want the primary field to be a concatenation of the value of a particular field in a linked table. Right now, it seems, that you can only access the primary field when making these links. Is there a way the value in another one of the linked records fields to show up and be accessible?
To pull in a specific field based on a linked record, you would use the Lookup field type. For example, here’s a simple table that tracks names and ages:
In another table, I can link to those names in one field, and then use a Lookup field to pull the Age information, using both to build a custom primary field formula: