Bob Can you send me a file with:
A small sample of the database containing the two tables in question and some sample rows and the form, and, if you have one, the application file or program that calls the form? I'm curious to look at this. David Blocker [EMAIL PROTECTED] ----- Original Message ----- From: "Bob Thompson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, May 11, 2002 11:20 AM Subject: RE: forms suddenly not working properly 6.5++ win 1.851 > 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/ > ================================================ 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/
