Forum Discussion

MatthewFaler's avatar
MatthewFaler
Qrew Member
5 years ago

One to One Relationships

I have an application which is related to a softball league, and as relevant here it has a table for teams and games.  Each game has (obviously) two teams (but can't be the same team).  What is the best way to create this relationship, I have not been able to figure out how to do a "one to one" relationships in a way that works.   Any advice is greatly appreciated.  Thanks.

------------------------------
Matthew Faler
------------------------------
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    One way would be to have two relationships between Teams and Games.

    The first relationship would be that One Team has many Games and the relationship would be via the field Related Home Team and the Proxy field would be set as the lookup field named Home Team.

    Then copy that Related Home Team field and rename it to be Related Away Team and set a Proxy field as the lookup of the Team Name called Away Team.

    But I don't know what else you want to do with the app,  but that is one way to set it up.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MatthewFaler's avatar
      MatthewFaler
      Qrew Member
      5 years ago
      I'm sorry I am at pre-school level and don't understand any of these terms.  Are you saying create a new table to join the teams and games table?


      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        I'm saying to create a Relationship where One Team has Many Games.  So not a new table but to join the two tables.

        But then because of the nature of baseball that is not so much fun just playing by yourself, there are always two teams in a Game.  Home Team which gets the last "at bat" in the bottom of each inning,  and the Away Team who bat at he top of each inning. So them make a second relationship the same as the first relationship, but get your field names correct for the Related Home Team and the Related Away Team and the respective Lookups for the Team Names.  

        Here is some help on Relationships

        https://help.quickbase.com/user-assistance/about_relationships.html

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------