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