General information
Category:
Coding, syntax & commands
>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 ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only