Merging/Importing Records from Multiple copies of the same database
I am still in the design/setting up process of FMPro 12, not got it installed on our server and as such gave standalone copies of it to various colleagues, trouble is I now have three copies of the same database with relationships, portals etc., I've tried doing a straightforward import but a lot of the fields are left blank, mainly the ones in portals or as part of a relationship, in fact only fields specific to that layout gets imported nothing else. Am I doing the import wrong? how do I get the three files consolidated in to one with all the correct information in the correct place?
Many thanks for any help, it is greatly appreciated.