Hi Daniel, You can do this if you have a unique identifier in each table by using the SQL Select function under the Query menu.
First, in the from tables box, ask for the table with the objects (ie your polygon table) and then the text table. Once your cursor is in the where condition box, click on columns and choose the two from their respective tables that hold the unique identifier so that your statement looks like: polygon.idfield = text.idfield (I made those names up) Click OK and you'll attach all of your records from the text table to the polygon table where their unique id's line up. Save a copy of the new table the query created and presto! Hope this helps, Ryan Morgan Aerials Express www.AerialsExpress.com -----Original Message----- From: Daniel Madre [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 08, 2003 2:41 AM To: [EMAIL PROTECTED] Subject: MI-L Combining two tables to get information Dear List, I have two layers, one containing polygons as objects and the other layer containing corresponding text id as objects.These tables does not have any colums defined. I would like to have combined information from these two tables. I need area of each of the polygon aganist the corresponding number. Any ideas to do this? TIA, Daniel ============================================================================ ============================= This email and any files transmitted with it are confidential and intended solely for the use of the individual's or entities to which they are addressed. If you have received this email in error please delete it immediately and notify the sender. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.Æ ============================================================================ ============================= --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5445 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5480