On Thu, August 16, 2012 10:51 am, Peter Cushing wrote: > If all you are doing is checking if the provnum is valid you could just > seek into both tables (assuming it is indexed). Should be quick enough. > > * assume open with above aliases and order set. > if seek(mytestvalue,'X1') or seek(mytestvalue,'X2') * value is ok > else * value not ok > endif
No, because I need these to populate a dropdown combobox for the user to select a provnum for querying. _______________________________________________ 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.

