AnsweredAssumed Answered

Roles Table in relationship pls help!

Question asked by marksanchez on Jun 8, 2013
Latest reply on Jun 8, 2013 by alas

Hi Guys,

Let me reinstate my previous question in something much shorter.

I have a Customers table and a Project table, related to each other. Now I am trying to add a 3rd table "ROLES" the reason for this table is beacuse I want to create a role for customers so they hava a different role in each project example: Wedding project= 2 related customers one bride the other groom, but the groom in this project could potentially be a father in other project or best man. I am assuming the ROLES table will be the child of both CUSTOMERS AND PROJECTS. My QUESTION Is this the best solution to integrate roles for a related customer to a project layout? Is any other better way to add a ROLE field without adding a table(like table occurance). Any help will be greatly appreciated. Thank you for your help!!!