I have two databases, from different departments, that share "some" information.
1. ContactsDatabase is based on individuals.
2. CompanyDatabase is based on facilities/locations of companies, with multiple(1-4) PointsOfContact and many AnnualData fields.
Both databases share the names of some contacts, but not all PointsOfContact are present in both databases.
CompanyDatabase is a single table in a database and some of the data fields must remain secure. The PointsOfContact in CompanyDatabase must be ranked by status(1-4). ContactsDatabase has multiple tables with additional relationships such as Memberships, EventInvitations, StaffContact, etc...(Most of ContactsDatabase's tables are linked on ContactID#)
I am lost when it comes to the best way to share the contacts that are found in both. Surprisingly, the users are even less experienced than myself.
The ContactsDatabase is already split frontend/backend on a shared file server, while the CompanyDatabase is currently in a single table on the same shared file server.