Multiple contacts linked to one project
Posted:
Wed Feb 24, 2010 6:55 am
by martin baarda
I'm working with projects and i would like to add multiple contacts to one project, and in contacts I would like to see to which project somebody is linked.How should i make this.
New seedcode costumer
Posted:
Wed Feb 24, 2010 3:56 pm
by John Sindelar
Hi Martin,
What we usually do is leave the existing contact-project relationship alone and treat that as the "primary" contact for the project-- or perhaps the company for that project.
We the create a new join table between Projects and a new instance (a new table occurrence) of contacts. This join table contains a field for the Project ID, the Contact ID and perhaps that contact's role on the project.
That should get your started but if you need more this is the kind of thing we'd be happy to do for you. Email me directly, john at seedcode.com if you'd like to discuss it.
Best,
John