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!!!
Question
Pulling values from one table in an app to a field in another table
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.