Subject Querying between databases
Author

I have many separate database files that have all the same structure, but hold data from different customers. In each database, I have a series of tables that are used to supply valid values through foreign keys.  These tables and the data they hold are exactly the same in each database.  When I need to update a valid value in one, I have to make that same change in all the other databases.  Is there a way to keep the valid value tables in a separate database and build queries that access these tables from a second database?  The goal is the have a single set of valid value tables, instead of multiple copies.