Conditional Value Lists
Good afternoon, all. I've posted in the forum a couple of times and I've never been let down, so here's my latest challenge.
I'm trying to create a multi-level series of "drill down" value lists for sports teams. The value lists are:
Each of these categories has an associated table with a PK field, a Name field, a upwards looking FK field for the associated higher level record, and several other fields with information about that record (ie. logo, etc).
My goal is to only show Leagues that pertain to the selected sport, only show the conferences of the selected leage, and then only show the division of the selected conference.
I can't for the life of me get the value lists to populate correctly.
Any input would be MUCH appreciated.