Creating proper relationship
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.