AnsweredAssumed Answered

Creating proper relationship

Question asked by RyanMcCoy on Oct 21, 2012
Latest reply on Oct 21, 2012 by RyanMcCoy

Title

Creating proper relationship

Post

     I'll be the first to admit that I am fairly new to using FMP. I have followed tons of tutorials and searched this forum, but can not seem to find an answer specific to my problem.  I will put it as simply as possible:

     I have a table specifically for "shows".  Every show has it's own record along with information about it.  

     I have a table specifically for "cues".  Every show has several (up to ~1000) cues.  

     I need a way to link the shows and cues together.   I would like to have the "cue_id" field in the "cues" table to be the unique key.  I would like it to be something like "showName_venue_cueNumber".  Hopefully you can understand what I am trying to do.  I admittedly do not understand how to create relationships properly, so as in-depth as you could put your reply, the better.  

      

     Thanks!

ss3.PNG

Outcomes