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 be...
Forum Discussion
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
Qrew Legend
Qrew LegendI'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
------------------------------
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
------------------------------