Pass multiple values between tables



Hello all

I have an ODBC in Access of 18 tables from a FoxPro application. I
dupplicate the tables from the FoxPro application so I can use the
tables (put together a database) and send them to my customers. The
customer fill the database, and send it back to me. Now I have the
customers information. I want to be able to create links between my
original FoxPro application tables and the database that my customer
have send me.

Any ideas of what is the best way to do this?

So far I have created a blank database, then create an ODBC from the
FoxPro application and linked the database from my customer. So I
basically have both databases (FoxPro and customer) in this new Access
file. I was thinking on creating a query to add the data from my
customer's tables to the FoxPro data?. I need some guidance in here
please

Thank you

.



Relevant Pages

  • Re: Need to open Visual Fox Pro 8 tables in VB6
    ... There are several formats of Visual FoxPro files. ... VFP6 and below are readable via ODBC. ... "database container". ... Data Sources. ...
    (microsoft.public.vb.database.dao)
  • Re: VFP 8 and ODBC connection
    ... Instead of the overhead of ODBC or OLEDB, ... If the tables are part of a database, ... Microsoft Visual FoxPro MVP ... dedicated application server and the database part of the software on ...
    (microsoft.public.fox.helpwanted)
  • Re: Foxpro sql limitations
    ... > I am developing an ASP application that has to interface with a Foxpro ... > database for some things, in addition to a SQL Server database. ... > connecting through ODBC and using Jscript as my language of choice. ... > where you can't have more than 20 items in an IN clause. ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Word mail merge with foxpro
    ... > I am trying to connect to a dbf fine not the database. ... >> I do not think you will be able to open a .dbc using ODBC by selecting ... >> using that approach (in the Select Data Source dialog, ... >>> Firstly the files of type drop down does not give a foxpro option. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Access 2000 run-time error 80004005 - HELP
    ... try changing the column definition (make a backup of the ... > destination table is a linked table originating from a FoxPro v3 database. ... it appears MS is letting FoxPro die a slow death. ...
    (microsoft.public.fox.programmer.exchange)