Hi Jonathan, Many thanks for the prompt response. I am the designer of the database although not a professional FM designer, merely a hobbyist.
Actually, both databases are the same on two different Macs with exactly the same fields but one contains data that the other does not and v.v. What I am trying to do is to get them to be exactly the same. A pity that there is not an app to merge the two. Is there an easier way to achieve this than going through the database record-by-record? Again, I do appreciate your help. Cheers Roger > On 6Jul, 2016 AD, at 11:11 AM, Jonathan Fletcher <[email protected]> > wrote: > > Copy and paste? > > You can copy the tables from one file into another and have both of them in > one file. You then import the data from the external file. > > That said, if you simply want to merge the data into one table and there > aren’t any duplicates, you can simply import from one to the other. > > If however there are data points that conflict or records with duplicate data > or IDs then all bets are off, and you will need two people to complete the > task: > > 1. Someone who knows the data intimately and how exactly you want it to end > up > 2. Someone who knows FileMaker pretty well > > From the wording of your question, I am assuming that you MAY be the former > and are likely not the latter. > > There will not be an “app” that will make the same decisions that your brain > would, if there is anything that actually requires a decision. (Believe me > there will be more decisions than you have already thought of. Happens every > time.) > > Jonathan > > > > >> On Jul 5, 2016, at 11:12 PM, Roger Adams <[email protected]> wrote: >> >> Hi Folks, >> >> I am looking for am app that will merge two FM databases. Is there such an >> app and if so, I would appreciate if you could advise where and how I can >> get it. >> >> Many thanks >> >> Roger > > -- > Jonathan Fletcher > [email protected] > > Kentuckiana FileMaker Developers Group > Next Meeting: 7/26/16
