2 Replies Latest reply on May 27, 2013 1:59 PM by philmodjunk

    Conditional Value Lists

    EvanStein

      Title

      Conditional Value Lists

      Post

           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:

           Sport

           League

           Conference

           Division

           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.

           THANK YOU!!!!