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:
Here is a snapshot of what I would like to see for the game:
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?