Think about using a temporary table and secondly you can build up a where clause using a &where clause
Tony From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: dinsdag 11 mei 2010 19:02 To: RBASE-L Mailing List Subject: [RBASE-L] - Multiple choice I want to get into an area I have not entered before so I will need some guidance. My goal is to have a form with multiple choices (either will check boxes or type in fields) that will print a report based on those choices.\ I assume I will need a series of Switch/endswitch codes. I foresee my question being, "How do you eliminate the NULLs in the choices and combine all the choices into a WHERE or SELECT clause. I looked at the example SelfDesigningReports in RRBYW14 but that is not what I want. Jim
