Aha! Thanks very much, that's it! The CASONOS table is a combo of CASONOS1 and CASONOS2. I wasn't aware that you could open .TAB files in a word processor. Thanks again!
Chris A. -----Original Message----- From: Gilbert Hach� [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:24 PM To: Chris Alexander Cc: [EMAIL PROTECTED] Subject: RE: MI-L How to identify base tables You may have joined files for your streets To help you verify if one of the table is a link file here's an exemple of Mapinfo Street file where the base street is link to an extra file to have the addresses (check if you have this type of data in the street.tab file) Exemple :Street1 and street2 will be opened, linked and create a new one call "street" !Table !Version100 Open Table "stree1" Hide Open Table "street2" Hide Create View street as Select STREET,FROMLEFT,TOLEFT,FROMRIGHT,TORIGHT,FSA_LEFT,FSA_RIGHT,CITY_LEFT,CITY_R IGHT,EA_LEFT,EA_RIGHT,CD_LEFT,CD_RIGHT,FCC,FCC_OLD,SPCAN_ID,SPCAN_ID_PREV,PR OVINCE >From stree1,street2 Where street2.MI_REFNUM=street1.MI_REFNUM If so, just make a copy of the file.(ex: save street as streetcopy)-Not the best solution and may cause problem (depending on projection, bounding, etc) but if you overlay the original and the copy and they look good -use it. It better to find the original file and work dirctly from it, if you don't loose any useful information given by the link Also, if you have problem finding your street file it maybe because of your workspace... Open the workspace with a text editor and you may find something like the following line: Open Table "street" as street_Califoria Interactive That line means that Mapinfo open the file "street" and rename it within Mapinfo. You will have Street_California" as your layer name in Mapinfo -be careful... Good luck Gilbert -----Original Message----- From: Chris Alexander [mailto:[EMAIL PROTECTED] Sent: January 8, 2004 14:40 To: 'Roberts, Michael'; 'mapinfo' Subject: RE: MI-L How to identify base tables As far as I know, I opened the tables in their original form. I haven't done any querying prior to my join. Are there some other clues I should look for? Chris A. -----Original Message----- From: Roberts, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 11:35 AM To: Chris Alexander Subject: RE: MI-L How to identify base tables Are you working with a sub set of the original data (i.e. a query) that is not saved as a tab file? That will give you an error sometimes. -----Original Message----- From: Chris Alexander [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 2:30 PM To: '[EMAIL PROTECTED]' Subject: MI-L How to identify base tables Hello, I'm trying to join CAXXXXZB (California Zip Boundaries) to CASONOS (streets in Sonoma County), but I get the "You can only perform dynamic joins on base tables" message. Both of these tables came with MapInfo. How can they *not* be base tables? Thanks! Chris K Alexander Marketing Data Analyst Advanced TelCom Group 19 Old Courthouse Square, Santa Rosa, CA 95404 Phone: 707-284-5395 Fax: 707-284-4259 [EMAIL PROTECTED] www.callatg.com <http://www.callatg.com/> --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9810 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9815
