Re: MI 'Geocoding' polyline layer to Access dB

[Geografía y Electrónica, SA de CV]

You can create a view, similar to StreetInfo tables, in a text file which
looks like:

!Table
!Version 300
Open Table "AvancesEjemplo.TAB" Interactive
Open Table "capaest.TAB" Interactive
create view AvanceObra as select * from CaPaEst, AvancesEjemplo  where
CaPaEst.numero = AvancesEjemplo.Carretera

And when you map this new table, you'll have all fields.   Make sure you
have a 1:1 correspondence, or no info will show.  You'll also need to have
both fields indexed, but if the Access table is ODBC, you may have
performance issues while creating the index, if the file is large.   So
maybe it's best to open the table directly.



At 07:48 a.m. 11/02/2000 -0500, you wrote:
>Hello All,
>
>I have a MI table with road names attached to road centerline polylines. I
>also have an access table with lots of info on each road and a column
>containing the road name.
>Is there a way of automatically linking each item in the access table to
>the correct road polyline (in a similar way to the 'geocode' tool) so that
>when I select a polyline, the info tool shows the corresponding access
>data?
> I don't know if I'm missing something obvious but my mind is going round
>in circles
>
>TIA
>
>Andrew Young
>Durham City
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
---------------------------------
     Ing. Juan Pufleau Correa
Geografía y Electrónica, SA de CV
      Aguascalientes, Mexico
---------------------------------
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]