AnsweredAssumed Answered

Hockey Game with Home Team and Visitor Team

Question asked by pademo57 on Nov 15, 2016
Latest reply on Nov 16, 2016 by philmodjunk

OK, I apologize for bringing this up again but I think I have lost my mind because I had this working and now, again, after turning off my computer I get the "<no values defined>" message.


I would like to have a way to select a Division and from there a conditional value list will only show those teams within that division.

I would then like to have the teams selected (Home team and Visitor Team)show up on another layout I call "Hockey Game" which I can then add actions that happen during the game such as Goal, or Shot or Icing etc.


Here is a snapshot of my relationship diagram:

Hockey GameA1.PNG

Here is a snapshot of what I would like to see for the game:

Hockey Game1.PNG

I can get the conditional value list to work if I use the Team Layout but when I move to the Game layout I get the message <no values defined>.


How do I get the names (Not the primary key) as shown above to show on the layout?