Hi everyone Hoping someone can help me with this, or clarify what is or isn't possible.
I have two databases (inherited from colleagues)that I would like to merge into one database. In each database: Table 1 has a one-to-many relationship with Table 2 Table 2 also has a one to many relationship with Table 3 The records in Tables 1 and 3 are identical in each database, but Table 2 has unique records in each database. Is there a way to merge both databases without losing the relationships between tables? I'd be very grateful for any suggestions or advice anyone can offer. Alison
