Filtered Value List

[Ballycroy]

Hi:

I have created a simple file to demonstrate what I am trying to achieve.

Basically I am trying to filter a value list to present the user with available position codes for a specific date.

I have used Ray Cologon's ZapValues custom function to filter the available codes and then used the field "ListAvaiablePositionCodes" for the value list.

The problem I am having is that when I create a record and select a date the drop-down menu sometimes displays "". If I click the "ListAvaiablePositionCodes" field the drop-down menu is updated.

I realise that there may be an easier way to do this, if so can someone let me know.

DynamicValueListFiltered.fp7.zip

Edited August 15, 2008 by Guest