>Hi,
>
>The Title of this thread could be misleading. I need to describe what I am considering.
>
>Several customers will be using my VFP application, the DB is in SQL Server database. Each VFP application has a separate database. But I am considering making one table to be a "library" for all databases. So I would create a separate database, just for this table (it is simplified but sufficient for understanding). So far, no problem, since I can make the application to connect to both, its "own/local" SQL Server as well as the "central" database where the "library" table resides.
>
>Now comes the challenge. Each record of this "library/central" table should have a value from a table in the "local/individual" database. And clearly, one field can have an entry from only one table.
>
>Example:
>The "library/central" table has field Vendor [ ] specifying which vendor is responsible for this record. But the Vendor table is specific to each database.
>One VFP application needs to have the Library Record 100 point to vendor "0001" in its database.
>Another VFP application needs to have the Library Record 100 point to vendor "ABC-222" in its database.
>
>How would you suggest to accomplish this? (if possible at all).

I don't think I understand the role of the library table. What's its purpose? What does one record there represent?

Tamar