Results 1 to 2 of 2
  1. #1
    Shamli is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2018
    Location
    California
    Posts
    142

    Form-Record Source- Two tables Left Join with one table

    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.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the 3rd table: tEmpProj should be keyed on 2 fields
    EmpID
    ProjID

    in relationships, join tEmployee.EmpID to tEmpProj.EmpID and tProject.ProjID to tEmpProj.ProjID
    you should be able to add projects to an employee thru a form:
    master form Project, subform tEmpProj and add employees to the subform.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-13-2017, 10:44 AM
  2. Replies: 12
    Last Post: 09-10-2015, 05:33 PM
  3. Left OUTER Join to more than one table?
    By oemar00 in forum Queries
    Replies: 3
    Last Post: 09-20-2013, 03:58 PM
  4. Count with Left Join on four tables
    By SheikhMusa in forum Queries
    Replies: 3
    Last Post: 04-09-2012, 11:15 AM
  5. Replies: 3
    Last Post: 02-02-2011, 01:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums