>>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).
>
>If I understand correctly, each app needs to have a key to its identity as a column in the central table ?
>But that is so simple that I probably misinterpreted the question ?

No, the question is not simple. And no, your understanding does not match the problem.