I'm very much a beginner in the many-to-many relationship arena. I've tried reading other people's postings and I'm still stuck on this subject because it's so new to me. I would love to hear any advice someone could offer on my specific situation.
here's the deal... I have a contact database and a database of marketing activties (i.e. a mailing, call campaign, email campaign, etc.). On the contact database, I have a layout set up with a portal to view all marketing activities linked to that contact. On the marketing activity database, I have a portal set up to view all contacts linked to that marketing activity. each contact has a unique contact ID and each marketing activity has a unique activity ID.
so my problem is: how in the heck do I set up these match fields and where do the various fields actually live (vs. portals that just view it from where it lives)?
I tried setting it up so that the match field is the activity ID but that means that each contact can only be linked to one marketing activity. similarly, I know I don't want the relationship based on contact ID, because then each marketing activity can only be linked to one contact.
does anyone have any helpful insight? I would also love to find a book that has a bunch of examples of how these many-to-many relationships work. any recommendations?
Thanks so much!!