Steve I would have to look into this, I have not used this approach before
What I am doing is a Physical therapy note system You can have 5 systems, other fields then the A B C for one column for a status Something like this Neck pain bla bla EMS,,,, A B C Knee pain bla bla Hot packs ... A B C being able to see the last visits treatments would be a big help and that's why I was looking at a region. Thanks for the input Marc ----- Original Message ----- From: Wills, Steve To: RBASE-L Mailing List Sent: Wednesday, March 04, 2009 5:14 PM Subject: [RBASE-L] - RE: Scrolling Region and DB Check box Not to be such a contrarian that you think I'm a heretic, but, is it that you MUST use a scrolling region? Would it be possible for you to perhaps use a Variable Form? It would require more coding, certainly, but it could open up a host of options for you to use on behalf of your users. I wouldn't have suggested this possibility, but . · Your desire to make it work AND make it work easy and "pretty" · Your mention (in a later message) that you have competition · Variable Forms was my solution when I ran up against a similar challenge some years back in the area of survey-based research Conceptually, and to the user, it could still work more or less like a scrolling region, but only one set of data would be presented at a time, rather than the many rows of the scrolling region. You could located buttons or other controls to navigate, ring bells, blow whistles, and whatever it takes to - what is it Razzak likes to say - blow the socks off your users' feet. I even did a little something along these lines over the weekend, just to test the logic of some ColdFusion functionality in a different application. My form had a bunch of checkboxes, an "All That Apply" type of thing. Due to design constraints on this app's database, we decided to concatenate the label values, 'CAPTION', from each button that was checked, then append it to a string variable with a comma between each CAPTION. IOW, a LIST! That way, we could make it easy, have a finite solution domain with discrete values (the CAPTIONs), and still reliably store it and search it. Well, I digress a bit. Anyway, it might be something to think about. Steve in Memphis From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, March 04, 2009 11:15am 11:15 To: RBASE-L Mailing List Subject: [RBASE-L] - Scrolling Region and DB Check box HI I am stuck on something that should be very simple. I have a Scrolling Region and would love to use a Radio Group but that is not possible. I have a text field with 1 character that I want to store A B or C Instead of having a DB Edit and typing in A B C, I would like to have the same type of look and feel of the Radio Group. I have played with Buttons and DB Check boxes but can't seem to get it figured out. Also I would like the object to be highlighted in when using the form so you can tell what the value of the field is. An I way off target or is this possible? Thanks Marc

