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!!!