Thanks, Geoff, for your input. Apologies for the late response but I have been rather busy over the last couple of days..
Cheers Roger > On Jul 6, 2016, at 6:40 PM, Geoff Graham <[email protected]> wrote: > > Import one into the other, which now contains all the data. Duplicate that > file in the Finder if you need two files. > > Geoff > > From: FileMaker Pro Discussions [mailto:[email protected]] On > Behalf Of Roger Adams > Sent: Wednesday, July 06, 2016 12:36 AM > To: [email protected] > Subject: Re: Merging two FM databases > > 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] > > <mailto:[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] > >> <mailto:[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] <mailto:[email protected]> > > > > Kentuckiana FileMaker Developers Group > > Next Meeting: 7/26/16 >
