On the first of the month I retrieve new data, so for example; today I am holding August in table 2, September in table 3. Table 1 holds all accumulated data. All three tables are identical from the design perspective. The primary key is a control # that is indexed with no duplicates. First I append table 2 to table 1, then delete the data in table 2, append table 3 to table 2, delete the data in table 3 and the new data is written to table 3. When appending table 3 to table 2, I am getting 280 key violations thus losing 280 records. Since the primary keys are designed the same I am lost on this one. Anyone offer a suggestion?