AnsweredAssumed Answered

Conditional Value Lists

Question asked by EvanStein on May 26, 2013
Latest reply on May 27, 2013 by philmodjunk

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!!!!

Outcomes