:) Here there are ones using MapInfo but I was never interested in. I prefer other GIS products like manifold, mappoint, mapobjects etc. I remember MapObjects support ODBC connections to external data or direct 'relations' to dbf files. Similar might be in MapInfo.
From within VFP sounds like you're using Activex? If so maybe you can code its events and create dbf on the fly for it to use via mapbasic? I don't know.
Cetin
>>OK final try:)
>>Create a view in VFP and mapbasic selects from that view?
>>Cetin
>
>Cetin
>
>HA HA! Would that I could. I originally wanted to drive MapInfo from VFP, via "Integrated Mapping", but the docn., examples, and expertise in this were very thin on the ground, and I couldn't get a toe-hold into it (doing it from VB was better docu'd). Hence, ALL the querying of maps is done from within a MapBasic app., which is invoked from VFP. Once inside this (when the query is generated, by the user clicking on a zone on the map), we're totally under the auspices of MB/MI. There's no way I can predict which data will go into the view in VFP.
>
>:-(
>
>I originally approached this problem WITH my knowledge of SQL but MB SQL is hopelessly inadequate. Jobs I can do with one SQL statement in VFP often require creating a table and do loops, etc.: reams of code (for instance it can't get more than 2 "look-up" descriptions into the cursor, via the main table's FKs)
>
>Terry