I am new to access and I am in need of starting a cumulative database. I can learn fast but I need the basics. I need to add table 2 data to table 1 which will be my main database. Sample Below:\n\nTable 1(Database)\nID Label\n1 a\n2 b\n3\n4\n5 e\n\nTable 2(new data to be added)\nID Label\n1 a1\n2 b\n3 c\n4 d\n6 f\n\nTable 1(AFTER UPDATED WITH TABLE 2 DATA)\nID Label\n1 a1 (changed per table2 update)\n2 b (no change)\n3 c (Updated per table2)\n4 d (Updated per table2)\n5 e (Record not in table2 therefore no change)\n6 f (Record added per table 2 and was not in table 1)\n\n****In general I want no duplicate ID's:\n1. If a record exists in both tables then update table 1 with table 2 data.\n2. If a record is in table 2 but not table 1 then add the record to table 1.\n3. If a record is in table 1 but not in table 2 then retain the table 1 data.\n\nAgain. I just need table 1 to be my main database with periodic updates or adds from table 2. I hope someone can get me started. Thank you.