Refresh a drop based on another form field

[Devan]

Hi all,

I have a form with a few entry fields on it, and a drop field at the end.

One of the first text fields specifies a filter condition for the drop field at the end.

How do I get the list of items in the Drop field to refresh when the text field is changed?

(NT6.09 by the way, on C8)

Thanks!
Devan

[John Fligg]

Devan - I figured this one out coincidentally just this morning.

When the field is entered I set a session variable rather like a parameter.

Then on the Browse lookup in the validate embed point I have something like:

If GSV(parameter)
   Set Filter
End

Remember to set that parameter session variable when you close the original form though!

HTH

John Fligg

[Bruce]

>> How do I get the list of items in the Drop field to refresh when the text field is changed?

add drop field equate to reset field list on client-side tab of text field.

cheers
Bruce

[Devan]

John thanks for your tips.  I tried Bruce's suggestion and it worked great with little effort, so I didnt get around to trying your method.

I actually had this all set up earlier, but I had a stupid bug in my drop down filter code so was getting nothing in the drop down regardless of what I did! 

All works now - thanks Bruce!