Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
8 years ago

Populate field based on table relationship with three matching fields

I have a main table called records, then I have a table called fee Sch.  I need to be able to add a field to the main table that shows me the fee sch from the fee sch table.  The issue that I have, is...
Relationships
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
You will need to create a data entry field for the Concatenated Key field and populate it with the values from the formula field.   You can use grid edit for that for the initial load up.

Then go to the field list and make that data entry field the Key field for the Fee Schedule Table.

Then make a relationship to the transactions table and lookup the fee.

Once you get that working, please post back and I will explain snap shot fields.