Dinamic valuelist

[lagartixa2001]

Hi, I 've a db that contains 4 fields:

fieldmain

fieldA

fieldB

fieldC

- When FieldA is empty, the fieldmain have to use a valuelist X;

- When FieldA and FieldB are empty, the fieldmain have to use a valuelist Y;

- When FieldA, FieldB and FieldC are empty, the fieldmain have to use a valuelist Z;

- When all fields are empty, do nothing.

Does it possible?:

[john.daly]

Create three global fields for your value lists:

ListX

ListY

ListZ

and a calculated field PopUpList where the calculation is;

Case(FieldA = "" and FieldB = "" and FieldC = "",ListZ, FieldA = "" and FieldB = "", ListY, FieldA = "", ListX)

Use this calculated field for the values in the popup list.