Patrick, I second what Ben says below. Forms working differently between insert and edit has always driven me nuts. I normally manually insert the row and then use the form in edit mode.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 3/07/02 1:00 am >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/ ================================================ 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/
