Hi
Can we do 2 tables left join with the third table? In the record source in a form?
I have three tables.
1. Employee
2. Project
3. Assign Employee to project.
I am building a form which has a sub form with the employee name lists. and a tab with the employee details and another tab with project details.
Goal is when the admin selects the employee. tab should refresh to show the employee details and the project allotted to him.
SUb form Employee list source - Employee Table
Now the project details tab has the data from the project table.
Now the complete main form source: (Employee table, project table) left join with Assign Employee to project table (This an adjunct table).
I am not able to build a query in the record source with all the three tables.
could you please help me with this.