mhawkins73
New Member
- Joined
- Jun 27, 2017
- Messages
- 6
I am hoping someone out there has an answer for this one. I am trying to get a field to automatically populate from one of three tables that is dependent upon possible values in two to three fields. Some context here is that I am tracking employee benefit enrollments. Each employee has three plan options to choose from that all have different prices that are dependent of their age. So if employee #1 chooses plan #2 and is age 45 then they have X price, it is that price I am looking to get populated from one of the three tables.
Additionally, this is further complicated that their are separate prices for each dependent and of course based off their age. I have collected the name, age, and plan choice for each employee and dependent they enrolled.
Is this something that is possible? I just have not been able to figure out how to incorporate the multiple factors that drive the result. Thank you in advance.
Additionally, this is further complicated that their are separate prices for each dependent and of course based off their age. I have collected the name, age, and plan choice for each employee and dependent they enrolled.
Is this something that is possible? I just have not been able to figure out how to incorporate the multiple factors that drive the result. Thank you in advance.