Link Text drop down box to flag field

[jchristoph]

I'd like to be able to create a custom drop down list for a text field and
then link the ability to choose something from that list to a flag field.
Anyone know how to do this?

 

[Jan De Messemaeker]

Hi,

It may sound like oversimplification but what else can I say but
- Customize the text field with a value list
- Customize the flag fired with an Iif formula using the value in the text
field
HTH

 

[jchristoph]

I tried using a formula in the text field to test for the flag, however I get
a recursive reference error if I try to use the drop down field based on the
flag being set. I was able to get around this by using two text fields and a
flag field. I use the Iif statement to test the flag, if true I reference
the text drop down list in the "dummy" field and put the value out in the
second field. This still does not solve my problem where I only want the
text drop down list to be valid if the flag is set to true.

 

[Jan De Messemaeker]

Aha! Now I understand the question - had an oversimplified view the first
time.
But Alas, I'm unable to find a solution that would combine a formula and a
value list, sorry
:-((