AmberAnderson
4 years agoQrew Trainee
Conditional Drop Down - Auto Fill
Hi, Hoping someone may have a solution for this. I'm sure I'm missing something simple.
Table: Employee
What I am trying to do is:
Is this possible?
I do have the conditional drop downs already working, just hoping to reduce a step in filling out the form.
Thank you :)
------------------------------
Amber Anderson
------------------------------
Table: Employee
- This table houses all employees. There will never be a duplicate instance of this employee
- This table includes - Employee Name and Employee ID
- This table includes the list of possible projects an employee can be assigned to.
- This Table Includes the Employee Name & Employee ID (Pulled from the Employee Table
- This Table includes the Project Name and Project Supervisor (Pulled from the Project Table)
- An employee is typically assigned to one project, however, they can have multiples.
- Additional Fields - Assignment Supervisor, Start and End Date
- This table will have a relationship with the Employee Table (pulling name and ID) and Assignment Table(pulling Name, Project Name, employee ID and Supervisor for Project and Assignment)
What I am trying to do is:
- When the Employee Name is selected if there is only one active assignment, it defaults to this.
- If there are multiple assignments - it requests a selection.
Is this possible?
I do have the conditional drop downs already working, just hoping to reduce a step in filling out the form.
Thank you :)
------------------------------
Amber Anderson
------------------------------