Jonathan, this isnt do-able in any 'simple' way, the four tables require four queries (of the select * from.... type) and you will get up to four 'tables' of results every time.
You could then 'append' those results together, but appending in mapinfo relies heavily on the four tables all having the same structure. (if yours do.. then just append away ... et voila) As an alternative i would propose that you write a routine to perform the four queries and then scan through the four results populating some custom data types with the apprpriate values from each row of the result tables (so if your VALVE table has columns like ID, SIZE,TYPE,PRESSURE your custom variable can hold all these values in one go...if your ID search returns more than one row in the result, you simply make the custom type an array..) at teh same time as you populate teh custom variables you use an array of object variables to store copies of the map objects returned by each result.. having populated your custom type variables with the data, you could then use the custom variable to populate a dialog box with the all the necessary values for the user to view (if the data is too much for one dialog, then use a 'switchboard dialog with 4 buttons to open the appropriate dialog for each result). the final task is also to populate a 'blank' map with the map objects from the four results.. (you can make a 'blank map by opening a mapper with one of the base tables present, but not visible, then simply add the object variables to the cosmetic layer....for continuous use you need to remember to wipe the cosmetic layer when the user searches for a new ID..for comfort you need to rig a routine to set teh map view to show all teh objects (use their MBRs) HTH R ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. . http://www.bgs.ac.uk ********************************************************************* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9775
