Correlation between 2 separated identical master tables and a 3rd shared one
We have 2 identical master tables, same type of fields and names etc, each containing records coming from different sources. For security and management reasons such tables (and records)have to remain separate. However there would be sometimes the necessity to sort out with a common key, records from both the tables and find them listed in common fields into a 3rd shared table(or portal or any other different solution). The perfect goal would be also to be able to update such sorted records and find they modified in their original master tables (as they would be correlated).