Pulling values from one table in an app to a field in another table

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I need to pull a value from a supporting table in the app (Dental cost) to a field (Coverage Tier) in another table based upon selection of coverage tier.  Essentially, I have some data tables that have dental coverage tier and an associated cost of each tier.

So, if I choose Employee Only (Coverage Tier) in the main table, I need it to look to the "Dental Table" and pull the coverage cost value matching the Employee Only (Coverage Tier).  The coverage tier language match in the main table and the supporting table.  There are five tiers (Employee Only, Employee + Spouse, Employee + Children, Family, and Waived).

I would like to be able to pull the valued directly from the Dental Table so when the values change annually, I can just make the adjustment in one place and all the associated employee's record in the Main Table will adjust accordingly.

Thanks in advance!!!
Photo of Aaron Zielinski

Aaron Zielinski

  • 272 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Is the Tier selection a relationship?  Any way that could just be a relationship between your "Tier" table and the "Employee" table?

Then that information could just come as a lookup field....

Maybe I missed something in your set up...
Photo of Aaron Zielinski

Aaron Zielinski

  • 272 Points 250 badge 2x thumb
Matthew, I'm a newby app builder (this is a new one I'm building) so no relationships are established.  I have built separate tables for employees, each of health insurance products (tiers), dental, and vision.  I'm basically trying to have if employee x selects product x and he's x years old, the premium will pull from the respective table into the employee's record on the employee table.  The premium tables are setup with age and premium as the two columns.
(Edited)