I'm new to using filemaker and would like advice on how to combine tables.
I get sales data from two sources -- Amazon.com and from an ecommerce platform. I want to combine this data into one table so I can create an inventory tracking system.
If I was combining data once, it woudl be easy to just map the fields when importing. However, I am going to be doing this every month and I'm concerned that one day I'll make a mistake when mapping and destroy the records in the data base.
I would much prefer to import the two files separately each month and then somehow combine them into one data table. (The field names do not match between the files.)
What is the best way, if any, to do this.