Alastair, Remember that R:base multi table forms automatically link on ALL common columns. Maybee your form is linking on some columns that you are not expecting it to causing this problem.
Troy ===== Original Message from [EMAIL PROTECTED] at 3/12/02 12:29 pm >Hello Razzak, thanks for your response. > >I've tried as you suggested and it works as you say - and as it does in my >database for multiple records. > >However, when I add "and Empfname = 'mary' " (which is the equivalent of >selecting one row as I was doing in my database) I get one record in concomp >and pressing either [F7] or [F8] does nothing - as it should. > >Conclusion: it's me/my database. > >Any ideas why this might be happening? The form is edit only with no EEPs >and simply for viewing data. > >Thanks & regards, >Alastair. > > > >----- Original Message ----- >From: "A. Razzak Memon" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, March 11, 2002 2:29 PM >Subject: Re: Strange behaviour with BROWSE USING as opposed to EDIT USING - >Razzak's Reply > > >> >> At 03:33 PM 3/10/02 -0000, Alastair Burr wrote: >> > >> >If I use EDIT USING a form with a where clause that picks >> >up only one row I can then press [F7] or [F8] and nothing >> >happens - as expected, there is no other row to go to. >> > >> >However if I use BROWSE USING and EXACTLY the same form >> >and selection criteria if I press [F8] only (not with [F7]) >> >I get a blank form - fields with no data. If [F7] then went >> >back to the data it would not be so bad but I can then not >> >do anything other than [Esc]. >> >> Alastair, >> >> Could you try the same scenario using CONCOMP database and >> see what happens? >> >> Example: >> >> CONNECT CONCOMP >> >> EDIT USING Employee WHERE EmpCity = 'Seattle' >> >> . Keep pressing [F8] key and you should see at least five >> records! >> >> Now, try the same using: >> >> BROWSE USING Employee WHERE EmpCity = 'Seattle' >> >> . Keep pressing [F8] key and you should see at least five >> records! >> >> Let us know. >> >> Very Best Regards, >> >> Razzak. >> >> ===================================-============================ >> Official R:BASE List Server: mailto:[EMAIL PROTECTED] >> RBTI Events/Training: http://www.rbase2000.com/events >> R:DCC Members: http://www.rbase2000.com/rdcc >> ================================================================ >> R:BASE, Oterro & R:Tango are registered trademarks of RBTI. >> ==================================-============================= >> >> ================================================ >> 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/
