I second that, Ben, edit only in forms as far as possible but particularly if there is anything complicated. Saves a few headaches!
Regards, Alastair. ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 8:00 AM Subject: re: Enter Using > 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/
