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.

Reply via email to