Thanks Dawn! I'm off to muddle this one through!
Lin On Tue, 19 Feb 2008 09:59:12 -0500, [EMAIL PROTECTED] said: Lin, Some of this depends on how you're opening the form from the start. Are you in ENTER mode or EDIT mode (enter using formname vs edit using formname)? There are a lot of ways to do what you need. First, check the table relations tab in the Form Properties: It should be set to Many to Many. When you add a row to the main form table, the remaining tables will 'clear' (because there is no linking data). Try it, press F2 while in any field in the first table to see what happens. Using PROPERTY TABLE Contacts 'APPEND' in your eep will achieve the same thing. However, I generally like to close out a form completely when entering / editing using a multi-table form. It is reassuring to me to know that the user is starting from 'scratch', with all variables defined as I want them, etc. I generally have a dialog asking the user if they want to enter/edit another record. I use the response variable as a flag, so when I RETURN to the calling command file or eep, the variable is checked. If it's yes, go back to the start, if it's no, go to the end (or do whatever is next). Think of each row in a scrolling region as a form within a form: How would you save a row and add a new one if it were not in a region? If in EDIT mode, you can use any method to add a row: In an EEP use ADDROW, PROPERTY TABLE tablename 'APPEND'; or press the F2 key (if not disabled). If you're in ENTER mode, pressing ENTER on the last column in the row should add another row. If under table settings you have Automatic Replacement checked (it's the default), then adding a new row automatically saves the data in the row the user was in. To leave one region to go to the next, you can use the mouse and click into the next table/region. (Again, in doing so, if automatic replacement is checked, the row the user was just in will be saved.) However, there are a number of ways to use keyboard shortcuts. I normally put a tab control on the form with each table's data on a separate tab. I use an acceleration character on the page name. So on the tab page properties, for the name Inventory, I would enter &Inventory. This underlines the I and allows the user to press Alt-I to get to that page. On the tab page eep, I have PROPERTY componentid SET_FOCUS 'TRUE', where the componentid is the component id for the first field in the region. So when the user presses Alt-I, they go right to that page, with the cursor in the first field they can edit. Again, there are a lot of ways to what you need to do.. I hope this has given you some ideas. Dawn Hast "Lin MacDonald" <[EMAIL PROTECTED]> wrote on 02/19/2008 08:44:28 AM: > I asked this on Sunday and it may have gotten missed so I thought I > would ask again. My apologies if it's just that there hasn't been > time to respond. > > I have a form that uses 3 tables. I want the second and third > tables to be in scrolling regions, but maybe this isn't the best way > to accomplish this? > > 1) How do I clear all the fields to input the next record if I use > the Custom EEP below? What do I need to add? At the moment, this > code adds the data from the 1st and second section, but not the > third, (why would that be?) and then leaves all the data still on > the screen, which is confusing for the User. > > PROPERTY TABLE Contacts 'POST' > PROPERTY TABLE CompContacts 'POST' > PROPERTY TABLE invntory 'POST' > RETURN > > 2) Regarding scrolling regions. I can't find much in the Help files > that explains how to use them. Can anyone point me to the proper > documentation? > > 3) I've added a scrolling region to the second table. How do I save > the first record and tell it that I want to add a second one? > > 4) How do I leave the scrolling region, save everything in it and go > on to the third section/table? > > thanks, > Lin
