Discussions

Expand all | Collapse all

One to One Relationships

  • 1.  One to One Relationships

    Posted 21 days ago
    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
    ------------------------------


  • 2.  RE: One to One Relationships

    Posted 20 days 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
    ------------------------------



  • 3.  RE: One to One Relationships

    Posted 20 days 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?





  • 4.  RE: One to One Relationships

    Posted 20 days 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
    ------------------------------