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.
