Duplicate records preventing Appended Table populating

Thanks Ross.

I found the spot and noticed that it was using a mixture of FileSytemObject and ID fields for the relationships.

I just changed them all to the GUID field as per below. I don't know if this is the right way to do it but it seems to have done the trick.

I'm thinking that these dont need to be true relational tables as i just want the records to append. Sorry i'm not a DB person, so i'm fumbling through here a bit.

Note: I grabbed 3 'identical' tables and then created a new append table.

Yes thats a good solution. Requires lets data manipulation so its a better solution overall.  You are doing it right.