Hi Joerg After a slight modification, this did the trick THANK you
What I did was > Use clients in 0 alias client 1 again Use clients in 0 alias client order 1 again On Thu, Nov 20, 2008 at 11:31 AM, Joerg Arand <[EMAIL PROTECTED]> wrote: > What about > Use clients in 0 alias client 1 again > Select .....into temp > sele temp > set relatio to clcode into Clients1 > .... > > > > > > Joerg Arand MD > assistant medical director > > Neonatology > Children's Hospital > University Tuebingen > Calwer Str. 7 > D-72076 Tuebingen > Tel.+49-(0)7071-2982211 > Tel.+49-(0)7071-2980895 (office) > E-mail:Joerg.Arand(AT)med.uni-tuebingen.de > > > >>>> "Sytze de Boer" <[EMAIL PROTECTED]> 19.11.2008 21:55 >>> > Friends > I've noticed this before but I've shrugged my shoulders. > Can someone help me > > Lets' say I have 2 tables, Clients and Trans > I have a form with a Grid, and a command button > This command button goes something like > > select * from trans where client="ABC" and between(date,X,Y) into able temp > set relatio to clcode into Clients > go top > report form (myreport) preview nocons > set rela to > use > > sele clients > thisform.refresh > > There are no clients ......................... > I have to exit the form and start the form again > > > -- > Regards > Sytze de Boer > Kiss Systems > Ph: 64-7-8391670, Mob:021 937611, > Skype: kissman2 > www.kiss.co.nz > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
