I've just checked. It does not change table. That ok. It does move pointer. So you can use Lookup(table2.field2,2,table2.field1) while being in table 1 and it stays on table1 but the pointer in table2 moves. Al
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 20 January 2015 15:58 To: [email protected] Subject: RE: using select in a case Tracy, Yes it does say that but must admit I used it before I noticed that and it always performed faultlessly. Either I was lucky or the doc may be incomplete. Dave --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/009f01d034c2$951b04a0$bf510de0$@com ** 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.
