Skip to main content

Question About Linking Records

M
Forum|alt.badge.img+20
  • M_k
  • Inspiring
  • 614 replies

Hi

I am wondering how to do this, I am a beginner with linking records, do I am just learning this:

When creating a linked record/table I should create two tables (in my situation), #1 TV SHOWS, #2 EPISODES, then I would create a field in the first table and link it to the field, EPISODE NAME in table #2 named EPISODES. I would go to table #2, EPISODES and link to EPISODE NAME in table #2, TV SHOWS, I would create all my other fields. Now, I am not sure what option I would chose, when creating links: Individual records or all records for TV SHOWS in table #1 and EPISODE NAME in table #2.

What is the rule for deciding if I should chose:

Individual Record
Or
Group of Records

Thank you,
Mary

    2 replies

    E
    Forum|alt.badge.img+17

    As Episodes belongs to just 1 TV Show, you uncheck “Allow linking to multiple records” in that table. As TV shows can have more than 1 episode, you choose “Allow linking to multiple records” in that table (if not, you could select just 1 episode for every TV Show :grinning_face_with_smiling_eyes: ).

    M
    Forum|alt.badge.img+20
    • M_k
    • Author
    • Inspiring
    • 614 replies
    • February 8, 2019
    Elias_Gomez_Sai wrote:

    As Episodes belongs to just 1 TV Show, you uncheck “Allow linking to multiple records” in that table. As TV shows can have more than 1 episode, you choose “Allow linking to multiple records” in that table (if not, you could select just 1 episode for every TV Show :grinning_face_with_smiling_eyes: ).


    Hi @Elias_Gomez_Sainz

    This is so helpful

    It is the last piece to this puzzle. I now have a better understanding, since I have to visualize the whole picture, to understand it better. This helps with that. :grinning:

    Thank you,
    Mary

    E
    1 person likes this
    • E
      Elias_Gomez_Sai

    Reply


    Most helpful members this week

    Terms & Conditions