Building conditional value list

[mdurg]

Using this solution:

I'd like to place a drop down value list in the RequestLog file to choose a SalesRep. Then a second drop down list below that one to choose a Customer. The choice for SalesRep should filter out the choices offered in the Customer drop down list. Is this possible to do given the relationships I have? How would I set this up? Do I set up the value list in the Customers file and call that from the RequestLog file?

Any help on how to start is greatly appreciated. I have been totally clueless on how to set up value lists.

[Ugo DI LUCA]

mburg,

In the RequestLog

1. Create a g_salesNo (global)

2. Create a Value List of Sales N