Option 1: You can create a relationship and use lookups.
Option 2: You can create a layout based on the table occurrence of the table from your second file, and set the values into variables from your first table, go to the new layout you created, and set the fields with the variable values.
I would like to go with Option 1: You can create a relationship and use lookups.
Can you explain how to do that? I have played with it unsuccessfully.
Start by setting up a relationship between two tables, based on regular number or text fields. For a lookup to work best, the relationship needs to be a many-to-one, or one-to-one, i.e. many (or one) records in the table should only relate to one record in the lookup table. Then, it's just a matter of check the Lookup option for a field, selected the table to lookup from, and the field that contains the value you want.