Conditional Lookup

Question

Hi All,

I am working with 3 tables and I have a form with 3 drop downs to connect the record to all 3 tables.
I am trying to find a way to get 2 of the 3 fields to auto populate.

The field in the Form that is filled out is the child to the table where the other 2 fields are pulled from. I'm hoping to get these 2 fields to auto populate.

The Image below shows the relationships and the fields they share as well as how the form is set up.
Any help is greatly appreciated :)

------------------------------
Amber Anderson
------------------------------

------------------------------Amber Anderson------------------------------

MarkShnierYou · Answer

Amber,What you are describing is a typical and proper setup to assign Employees to Projects.The Employee ID would be a lookup field from the Employees table along with any other lookup fields you like.The drop down list of employees can be filtered to only show active Employees, but I'm not understanding your "ask" to have it be filtered for "Active Assignments".I'm not understanding how the drop down list for Projects could auto populate based on the employee selection since the setup you have looks to be the place where employees are assigned to projects.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community