AnsweredAssumed Answered

Am I on the right track here? How can I solve this many to many problem?

Question asked by DanF on Feb 23, 2012
Latest reply on Feb 27, 2012 by philmodjunk

Title

Am I on the right track here? How can I solve this many to many problem?

Post

Second post today, I'm on a roll! Okay so I'm new to FileMaker and relational databases, thus I need help. First of all, looking at the attached screenshot, am I on the right track here, i.e. one contact can have many photos but not the other way around, and the same goes for shoots and photos? I'm just learning here, so comments are much appreciated. Ignore my field names, as I'm just exploring for the time being.

Now for my dilemma. One shoot can have many locations, yes, but one location can also have many shoots! How do I deal with this and how does it apply in the real world? This for a photography business database, though it will hopefully eventually have many more tables. Like I said, just exploring for the moment while I learn Laughing

Screen_Shot_2012-02-23_at_6.13.19_PM.png

Outcomes