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
MarkShnier__You
Qrew Legend
Qrew LegendOne 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
------------------------------
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
------------------------------
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__YouI'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
------------------------------