Good morning Tom, Thank you for the suggestion below. I do indeed have (1) column in each table with the same name. In the relational model, as I am sure you are aware, is what links the tables. In my case, where the form is entering sales orders, I have the column TICKET (Integer) in both the header and detail tables. This should be the normal practice I think.
In any case, I did try your suggestion and I renamed the TICKET column in my detail table to DETAIL# and set the value = to TICKET. When I used the form, it behaved in exactly the same manner as before. When I enter data into the header, then Shift F8 to the detail table and enter that information, then Shift F7 back to the header all is OK. But if I Shift F8 back to the detail table, it adds a duplicate display of the last record entered. I even tried preloading data and use the EDIT USING instead of the ENTER USING commands and you get the same problem. I am sure that this must be a bug that needs fixed, but would greatly appreciate any other suggestions anyone might have as I really need to finish this app. I know I could use two forms etc. but I would rather keep it as straight forward as possible. Thanks all. -----Original Message----- From: Tom Grimshaw [SMTP:[EMAIL PROTECTED]] Sent: Saturday, May 11, 2002 4:04 PM To: [EMAIL PROTECTED] Subject: Re: forms suddenly not working properly 6.5++ win 1.851 G'day Bernie, Look at the table definitions to see if there are two or more columns with the same names. If there are then the appearance of one row in the form was due to the same values being in both the header and detail table for that row. At 21:52 10/05/02 -0400, you wrote: >2 table form -- header table and detail table -- one to many relationship. >I created the form based on the header table, then add the detail table >and create a region. > >the region has 10 rows. a particular data set has 15 detail rows. > >header table is called BOM, detail is called BomDetl, form is called BOM >edit using bom where partno="01-B00" >The header data shows up fine. >In the region only the last row shows up in the first row in region. > >What has suddenly gone wrong? This is a new database and is the second >form I created that has 2 tables. The first form works fine!! Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au "... the control of impulse -- is the first principle of civilization."-- Will Durant, Pulitzer Prize winning philosopher, writer and historian the most needed product in the world can be found at www.thewaytohappiness.org This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. ================================================ 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/
