AnsweredAssumed Answered

Correlation between 2 separated identical master tables and a 3rd shared  one

Question asked by FrancoT on May 2, 2014
Latest reply on May 8, 2014 by FrancoT

Title

Correlation between 2 separated identical master tables and a 3rd shared  one

Post

 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).

Outcomes