AnsweredAssumed Answered

Many to Many Relationship

Question asked by farmerken on Jan 30, 2012
Latest reply on Jan 31, 2012 by comment

Hi, Newbie here. I can't get my head around many to many relationship. Using FMP 11. I have a list of contacts that I visit and give training to. Sometimes one contact is present sometimes several. The lesson material is tracked to be sure all lessons have been received by all contacts. I think I need a join table to allow for multiple lessons to be taught on one visit to multiple contacts. I think my entities are Contacts, Visits and Lessons. What should my relationships look like in there simplest form?

I have tables for Contacts, Visits & Lessons. Trying to be able to layout a visit screen where I can choose contacts who attended, and what lessons were taught. Then be able to generate individual records of instruction.

Any help is appreciated. Thanks