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?