Patrick, fwiw, I only use forms in edit mode w/out a menu or task bar. When adding a new record, the preceding routine gets some kind of identifier (inv#, cus#, key from another table, etc...) and does inserts to create the record to edit. When a region is involved, there is some logic to maintain a certain number of empty lines. This logic is reapplied in subsequent edits. And, (very important) there is a routine to clean up unused rows under certain conditions (like the close of the month). This evolved out of necessity, but I've grown to prefer it. The user doesn't need to press a button. I discovered that while you're doing the inserts, I'd think of other things to go along with it to make the system friendlier, etc. Ben Petersen
<<Patrick Murphy wrote: I have a two-table form, with table two having a region and tiers. This form works great using EDIT but when using it to Enter data, I am getting an odd result. I have a button set up under table 2 to add a new row in the tier, using the pre-defined action. However, when I click that button, it saves the data into table 1 AND table 2, erases the entered data and gives me a blank form. I just want to be able to add more than one record in the tier. Any help will be appreciated as usual. Pat Murphy [EMAIL PROTECTED] >> ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
