AnsweredAssumed Answered

How to combine to complex database (merge or import)

Question asked by on Nov 20, 2018



I'm trying to merge to identical complex database into a single one. The records are different but tables, fields, relations etc are the same. Alternatively I could import the records from one database to another. However I don't know how to do it. When I import records I can only import from one table to another, and I need to transfer them with all the related tables.

It's a public health database where every patient has his own ID and then several tables (with several fields in each table) all related to the patients. For example:

- Table 1: antropomorphic features: height, weight, color of the eyes etc

- Table 2: previous diseases: diabetes, stroke, etc

- Table 3: addres and telephone number



Anyone who can help me?


Thank you