Thanks for all who made suggestions, I haven't had time to work through them yet, but as soon as I have found the best solution, I'll post it. Juan Pufleau Correa suggested: create the following workspace - Open Table "AvancesEjemplo.TAB" Interactive Open Table "capaest.TAB" Interactive create view AvanceObra as select * from CaPaEst, AvancesEjemplo where CaPaEst.numero = AvancesEjemplo.Carretera Making sure there is a 1:1 correspondence and that both fields are indexed. Christer J suggested: First open the Access tabel in MapInfo. Then Update column. Tabell to update is the MapInfo road tabel. Get value from the Access tabell. Add a temporäry column. Join roadname columns. This join stored in the workspace. I use this to fault-localize. Ewa Platchta pointed out that Access cannot store spatial data except for points. So if you want to have the data in Access but the polyline in Mapinfo, then you have to have the same ID in both, and join them together using ODBC. Thanks again Andrew Young ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]