How to join a table to detailed form view

[crowden]

Hey,

Here's the form view I need to join to. (Employee Profiles)

http://fwc.tolsdevelopment.com/inde...&fabrik__cursor=2&fabrik__total=19&tableid=22

There's a table of projects that have join elements to employee profiles (for project managers, superintendents, etc..).

How can I list those projects that are associated with that employee, whether they be a project manager, superintendent, etc..?

Thanks for any help.

 

[rob]

you'll probably need to create a employee_project table

id
employee_id
project_id

then join the employee table to the employee_project table and then to the project table.

If you just wanted to list the project name you could get away without joining to the project table and instead make the employee_project project_id column into a database join element.