0

Need Constraints

'Planning Data' table:

Relationship field: 'a_Project' →  to Projects table N:1

Relationship field: 'a_Employees' →  to Employees table N:1

'Employees' table:

Relationship field: 'Projects' →  to Projects table N:1

So I want in 'Planning Data', when you select an employee in 'a_Employees', the 'a_Project' field to only show projects that are related to that employee.

1 reply

null
    • Fred
    • 2 wk ago
    • Reported - view

    The code would look like:

    a.a_Employees = b.Employees

    But with how you set it up, you can only have 1 employee per project, ever. You will need a M:M table between Projects and Employees if you want 1 employee to work on different projects or have more than 1 employee working the same project.

    If you add an M:M then that changes the code.

Login to reply

Content aside

  • 2 wk agoLast active
  • 1Replies
  • 27Views
  • 2 Following