AnsweredAssumed Answered

Conditional Value List Issue

Question asked by jrobgk1 on Jan 28, 2013
Latest reply on Jan 28, 2013 by philmodjunk


Conditional Value List Issue



     I have a table "Event Records" that i have created a relationship to a "Distributor" table, which holds a DistributorID and DistributorName as well as a RepID and RepName.  The DistributorID is related to a "houses" table, which holds a HouseID and HouseName.

     I need a conditional value list, so that when you are in an event record, you can choose a distributor (from a value list derived from the table Distributor), and then based on that selection, a list of RepNames are available for you choose from.

     I have a relationship from a field in event records::RepID to Distibutors::RepID.  I can not get a related value list to work.  what am i missing?