Tom Cloud wrote:
> My task is to create a form where the user can examine up to six options per
> line be able to set or reset any one of them (a checkbox). But the number of
> rows exceeds what can be displayed on a monitor.
>
> I am working with an existing table where the options are stored in a
> character field as a series of T or F example: "TTTFTF".
>
> The database is a set of definitions and the "switches" tell where those
> definitions will be used. There are 78 definitions by default and more can
> be added by the user. I've seen as many as 130.
>
> I put this in a grid, but the switches in the single character field make it
> a PITA -- I'd like to have a checkbox for each option in the character field
> and I don't know how to do that with the grid.
>
> At this time, only six switches are used, so I'm looking for a scrollable
> form that will have a header and between 78 to maybe 150 lines with a label
> (the definition) and six checkboxes per line.
>
> I will appreciate any suggestion you can offer.
>
> thanks,
> Tom
Assuming you can't change the table structure, I'd use a grid and have
the datasource a readwrite cursor with logical fields and checkbox
controls. In the form init soemthing like this:
SELECT IIF(left(mycharfield, 1)='T', .T., .F.) AS option1, ;
IIF(substr(mycharfield, 2,1)='T', .T., .F.) AS option2, ;
IIF(substr(mycharfield, 3,1)='T', .T., .F.) AS option3, ;
... and so on.
When finished editing, save the cursor data back to the table in the
reverse way.
--
Cheers
============
Brian Abbott
============
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
