Field lookup sql

Applications Forms
#1

Hi,
Is it possible to have 2 lookup sql on one select field?
For example, I have a radio button with 2 options.
If radio1 is selected, the select field lookup is “select * from table_a a where a.field_1 = {field1}”
If radio2 is selected, the select field lookup is “select * from table_b”

I put the query on each radio option value, and use ajax processing. It didn’t work.
Is it possible? Can anyone tell me how?

Thanks a lot!

#2

Try using a global var as table name in your select, and onChange of your radios modify global var value

#3

I have the same problem. Using Global Variables for something like that is very bad practice. It seems like there is some bug in SC. I noticed this problem long time ago. Had to deal with globals, but I’m not happy doing it this way. Global VARs should be avoided is possible.