Conditional Lookup

Question

Hi All,&nbsp;I am working with 3 tables and I have a form with 3 drop downs to connect the record to all 3 tables.&nbsp;I am trying to find a way to get 2 of the 3 fields to auto populate.&nbsp; 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.&nbsp;The Image below shows the relationships and the fields they share as well as how the form is set up.&nbsp;Any help is greatly appreciated :)

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

markshnier__you · 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------------------------------

amberanderson · Answer

Hi Mark,&nbsp;I can get the drop downs to reflect what I need ( Active assignments and such)&nbsp;What I am stuck with is when I select the drop down for the appropriate active assignment, I want to have the fields&nbsp;Employee ID (pulled from the Employee Table)&nbsp; and&nbsp;Project to auto populate.&nbsp;Essentially I need the record I am creating to also link to those tables&nbsp; and not just the Assignment table.&nbsp;I hope that makes more sense :)------------------------------Amber Anderson------------------------------

markshnier__you · Answer

The way to do that is to add more lookup fields to the relationships, to lookup those values down to the Assignment record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

amberanderson · Answer

Hey Mark,&nbsp;I'm not sure I am following.&nbsp;Currently the Table I have built (Development Table) has a relationship to the Assignment Table, Project Table and Employee Table which is creating 3 drop down fields in order to connect the Development records to the Project Table, Employee Table and the Assignment table.&nbsp;the first drop down that is filled out is the Assignment Drop Down where the employee name and assignment are selected from the single field.&nbsp;Once that field is filled out - I am trying to get the field associated with the Project and Employee to auto populate with the project and employee&nbsp; related to the assignment selected.&nbsp;I can pull that data from the assignment drop down with added lookups from that table, but it doesn't link it to the Project/Employee Tables. Unless I am missing something.&nbsp;Thank you :)------------------------------Amber Anderson------------------------------

markshnier__you · Answer

Ah, so we have a 4th table.&nbsp; I was not aware of that.One way to get the fields on the development record to populate is to use a form rule that says when the&nbsp;[Related Project] is not equal to the value in the field [lookup of Related Project from Assignments]ActionChange [Related Project] to the value in the field [lookup of Related Project from Assignments]. That that rule to fire all the time (uncheck the checkbox at the bottom of the form rule)You would have a similar form rule to populate Related employee.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Conditional Lookup