Hi Thomas I would recommend adding a field to your standard structure to contain the source table. Then using update column you can update this column with the alias of the table ( or better use a smallint field with a number and have a relational table with the smallint and the alias which will keep tables much smaller ).
Next for each table select * where field = "LA" into TAB1 then TAB2 and so on. Finally add TABn to TABn-1 etc to get all together. This sounds laborious but in MapBasic it would be straight forward. If you've got MapBasic and need more details to put into a program just give us a ring on 01874 622569. If you have not got MapBasic the above procedure will work manually but the more tables then the more laborious it gets. Hope the info is of use to you. Regards bob www.mapsbydesign.co.uk In message <[EMAIL PROTECTED] .police.pri>, Rodger, Thomas 11004 <[EMAIL PROTECTED]> writes >Hi List, > >I've got a very basic query, and any help would be greatly appreciated. > >I have a group of tab files loaded in MapInfo. Each of the tables has >exactly the same structure. I need to select a few objects from each of the >tables, all with the same value e.g. Field = "LA" >The result I need is a single table with all of the objects, and an >attribute from the name of the table that the object comes from. > >From what I remember MapInfo cannot select from more than one table at one >time, (Is this correct?). In which case is there a way to join up all the >tables into a master table, but creating a field that has the name of the >originating table? > >Many Thanks in Advance! > >Thomas > >_______________________________ >Thomas Rodger >Mapping and Data Officer, ICT >Surrey Police >Mount Browne, Sandy Lane, Guildford, GU3 1HG >Extension: 2352 >Direct Line: 01483 482352 >Email: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12623
