I'm sorry to keep rehashing this but I've run into a problem that I can't solve.
In my previous post I followed what philmodjunk suggested for a conditional value list and it worked...
...Until I turned off my computer and turned it back on later only to find my conditional value list not working.
The Division Table has a relationship to the Team table Hockey_Division::__pk_DivisionID - Hockey_Team::_fk_DivisionID
I have added some pictures to make it a little more clear:
In this layout I am using Hockey Division table and the popup menu lets you select which Division
When you try to select a team in that Division when you click on Team it says <No Values Defined>
Here is a picture showing how I set up the Conditional Value list:
But as I stated it says No Values Defined.
What have I done wrong?