Skip to main content
Question

One to One Relationships

  • October 6, 2020
  • 0 replies
  • 188 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement