Hi All,
Just wondering if it is possible to select a record with a certain value
from a set of tables if you don't know which table the record is in?
Let me explain with an example:
Tables Fields
Swr_MH Asset_ID
MH_No
Swr_Pipe Asset_ID
Pipe_No
If I have both tables open in MI and would like to select the record with an
Asset_ID of 09563 but am unsure of which table it is in, is there a piece of
code to achieve this sort of thing?
I want to build an mbx to perform a search on all open tables, for the table
and record containing an Asset_ID entered by the user, and than to select
that record.
Any help greatly appreciated and of course I will Sum.
Regards,
Scott Barling
GIS/Assets Technical Assistant
Eurobodalla Shire Council
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
