In your enter using form, create a global variable (it's defined in the macro you are using to call your form) to save the autonumbered column. In your eep, insert into table2 (recordnumber) values (.savednumber) and the same for table 3. Then exit the forms and do edit using sameform whee recordnumber = .savednumber. Better yet copy the form and eliminate the first part leaving only table2 & 3
Also remove table 2 and 3 from the enter using form Bernie Lis Megabytes, Inc. ----- Original Message ----- From: "Rhett MCPEAKE" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 3:40 PM Subject: Update in Form > I am a novice at using eep procedures. I want to accomplish the following in R:Base 6.5 for Windows. > > I have four tables connected together by a common column, recordnumber, which is an autonumber column. > > When I add a row to the MASTER table, I want to populate the other 3 tables with a row with the recordnumber of the row just added to the MASTER table. > These other three tables will have values put into them later on in the same form. > So, I have a form that adds a row to MASTER with recordnumber 1, later on in the form TABLE1, TABLE2, and TABLE3 will have information added that all together will make the entire recordnumber 1. > Thanks for any help. ================================================ 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/
