Option list that includes mysql query

[johnbleck2]

Is there a way to take an option list that is pulling data from a different form field in a different form and apply a where clause?

ie: dropdown - using field "secname" from form3.
... select form3.secname WHERE secpub = 'PUB1'

IF this can be done, where would I do it?

[Joe]

Hi John,

There is no default way to do this. You will need to customize the code to implement that requirement.

Cheers,

Joe