Kevin King

Radio Button Conditional

Recommended Posts

Kevin King

I’m trying to get a query to run based on the selection of a radio button.

If Student ID box is checked I want to use EB_SID, if Population Selection box is checked I want it to use Memo_SID as the conditional.

 

Anyone have an idea what to put in the conditional? In layman’s terms looking for:

SPAIDEN_ID =

(If RB_Choice = Single then use  :EB_SID ) or (If RB_Choice = Multiple then use :EB_Memo)

 

Form Design:

image.png.d70ae5845080f97643a5aa00ee4b7767.png

 

Radio Button: 

image.png.622ad096a597c03e98236b3bf77cbc1f.png

 

Thank you for any help! 

Share this post


Link to post
janejarboe

Not completely sure of the context here, but

maybe try a case statement:

 

SPRIDEN_ID = (  CASE  WHEN :RB_CHOICE.VALUE = 'Multiple'   THEN  ;EB_MEMO

                                              ELSE :EB_SID

                                     END ID_CHOICE  )

 

  • Like 1

Share this post


Link to post
Kevin King

Very clean, thank you very much!

Share this post


Link to post