Thanks Tony and Albert. I will work on that this week. Jim
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Tuesday, May 11, 2010 12:34 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple choice Here's how I do it CREATE TEMP TABLE tCustPick ( + CustID INTEGER, + CustName TEXT (40), + CustPick TEXT (1) ) I then base a scrolling region on the form, using a check box for CustPick so that the region lines come out sort of like this [ ] Ambulance Chasers Attorneys [ ] Smith's Insurance [ ] Johnson's Mortgage Brokers I also provide two buttons [Select All] and [Select None] for user convenience. [Select All] uses this eep UPDATE tCustPick SET CustPick = "T" WHERE CustID IS NOT NULL PROPERTY TABLE tCustPick "REFRESH" RETURN The where clause to print the report then includes this WHERE CustID IN (SELECT CustID FROM tCustPick WHERE CustPick = "T") Albert Jim Belisle wrote: > > 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 >
