>Hi,
>
>I have two programs that need to share one table. One is VFP( using free tables) and the other is VFP using SQL (7.0). The two programs need to share the customer table. I would like a some advise on how to tackle this problem. Should I create a routine in the free table program that uses the table in the SQL database or the other way around (I think this might require lots of programming)? Or would it be best to create a trigger within the SQL database that updates the free table? It seems to me that both ways might create trouble. Anyway, what is the current thinking on sharing the tables?
>
>John
Is the customer table in the SQL Server DB, a local/free table, or a table in a VFP DBC? I think you are better off having the customer table in SQL Server, then create a DBC for the "free table" VFP app where you can create a remote, updateable view of the customer table.
Mark McCasland
Midlothian, TX USA