Steve, I use DB Grids a lot for text heavy info. Bottom half of a form is the read only, sortable grid with 1 line summaries of whatever fields you want and a row color you like so the user knows where they are. Top half of the form is a blown up version of the DB Grid line you selected with separate, edit and non-edit fields. In your case I would have a non-edit date and time field, a non-edit history, and an edit note. I tend to color non-edit fields some version of yellow, leave edit fields clear, and turn fields being edited/spell checked to 'aqua'. The non-grid history and note fields can be big enough (10+ lines, 40 characters wide) to handle a large paragraph for easy reading or editing. Seems to work well.
Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 W- 217-245-9504 F - 217-245-2350 E - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Steve Breen Sent: Friday, June 04, 2010 11:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Form Question in 7.6 and Extreme The only issue I am struggling with is that I only need two columns from the table and one (notes) has to editable. Basically you have to be able to read the history of the incident and then edit the notes not the data and time as needed. This is working in 6.5++ Dos but an working on new form 1st in 7.6 Stephen Breen ________________________________ From: [email protected] on behalf of Albert Berry Sent: Sat 6/5/2010 12:11 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Form Question in 7.6 and Extreme You could also use a DBGrid which allows the user to click the column headings to resort the data, and to change the column size with standard windows click and drag functionality. I commonly use scrolling regions, but normally when data needs to be changed. A DBGrid has more functionality as a display device, particularly if it is set as read only. Albert John Engwer wrote: > > Stephen, > > I assume from your message that all of the data is in a single table. > If so, you could use a scrolling region to display multiple rows of > data. > > John > > > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of > *Steve Breen > *Sent:* Friday, June 04, 2010 9:18 PM > *To:* RBASE-L Mailing List > *Subject:* [RBASE-L] - Form Question in 7.6 and Extreme > > > > Is there a way to list multiple rows of data from a table in a form > from a table. > > > > IE: > > > > Column1 - Column2 > > Time_Stamp - Notes > > > > > > Dispalaying Data as follows: > > > > 1-1-2010 01:10 - this is note 1 > > 1-1-2010 01:11 - this is note 2 > > 1-1-2010 01:12 - this is note 3 > > 1-1-2010 01:13 - this is note 4 > > 1-1-2010 01:14 - this is note 5 > > > > Thanks for any help > > > > > > Stephen Breen > > >
