AnsweredAssumed Answered

Assigning single employee record to multiple project records

Question asked by JeffMurchison on May 22, 2013
Latest reply on May 23, 2013 by philmodjunk


Assigning single employee record to multiple project records


     I started using Filemaker about a month ago to build a project management system for our office. So far it's been working great. I can use it to create projects and assign employees to them.

     I initially started by heavily modifying one of the templates and I've run into a bit of an issue. As it stands right now, there are two tables; projects and employees. When I create a new project record, I can add employees to it (via a portal) so I can keep track of who is working on it.

     When I add an employee to a project, it creates a new record in the employee table. As you can imagine, this means that I end up with duplicates if an employee is working on more than one project. 

     What I want to do is just have one employee record for each individual employee, and then link that record to multiple projects. The problem is that I don't know how to go about linking one record to multiple ones.

     Any advice would be greatly appreciated!