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
CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
8 years ago
Okay, I get the concatenate field.  I did a formula field in both tables to concatenate the three fields together so they would match. I made the key field of fee sch table the formula. Now I'm a little unsure how to do the next part.  I want a field to auto show the correct fee sch number based on the two new concatenate fields.