Clients was moved to EOF() which can play havoc with the grid. Before clearing the relation do a LOCATE. This will put the temp table/cursor back at the top and move the record pointer back to a valid record in client.
HTH, Tracy -----Original Message----- From: Sytze de Boer Sent: Wednesday, November 19, 2008 3:56 PM 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 _______________________________________________ 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.
