Karen, I do exactly what you are describing in many forms. A menu often drives the "where" clause for the data before starting the form. The top half of the page is to edit data or selected fields. If the row is large, I pick the fields that make the most sense for the space available. Often add buttons to add rows and/or go to more detailed edit screens for rows with more fields than I can get on the screen. The bottom half has a DB Grid or scrolling region that holds basic read-only summary info to make sure you hit the right row. There are usually 15 summary rows and these rows may simply be ID info, a couple of fields, and the first12 words of a note. The top half will have the same info, add 10 more fields, and show as much of the note as I want. Each row is set to row edit. Some forms use views or tables depending on the use. Every form usually has a report button for the data in the form. PROPERTY Refreshes are used as needed. Works great.
Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 18, 2008 8:46 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Batch-Oriented Data Entry Form w/DB Grid to Display New Rows Jan: I'm still not sure I'm following you, but would this work: I'm assuming the "top" part of the form is an editable row of data? So make this table the primary table of your form. And I'm assuming the "bottom" multi-row part is for display only? If so, then create a view (even if it's a single-table view), including the appropriate "where" clause (like "where batchno = ..."). Then put a DBGrid or a scrolling region for that view on the form. You should make all the fields read-only. After you make the changes to the top, create an "on after save" eep to do a PROPERTY TABLE viewname 'REFRESH' Karen I am trying to do something very simple: Set up a batch-oriented data entry form with a multiple-column 'data view' (of any kind) This 'data view' must reflect the change immediately when a row is added, but must only show rows from the current batch Lastly, when clicking on a row, I want to be able to edit the data using my DB Edit fields on the form (DON'T need to edit anything IN the data view - it's just a reference list) I've Tried a Variable Lookup ListView, but the rows disappear when I click on them. I've tried a DB Grid, but I can't determine how to specify a current batch rather than display data from an entire table. Jan - you've been very helpful so far...I hope this rewording makes more sense.
