Am I on the right track here? How can I solve this many to many problem?
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