>>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

This one - library - table has list of certain procedures that will be used by multiple customers. That is, the same procedure, for example No 1234, will be assigned to asset "ABC" for one customer and to asset "CBC" for another customer. Currently each database has this Procedure table. But in this case, the Enterprise customer wants all of their sites to share the same procedures.
Does it explain the case?