I am planning my Access DB.
We want to create a product table with unique id, from the ERP - But as the ERP deleted history once sales are invoiced, we want to maintain the history in Access. Hence we would regularly download the product usage data from the ERP into a new table
Or can we import to one table, would that table overwrite and loose the data.
So the plan is to download into a new table, but then I want to merge the new and old tables and preserve the historic data. But how do I merge the two sets of data tables -all fields will be the same in each. I am using Access 2010.