Sycronising tables

[tomlee]

HI

i have 3 tables of which the data is all connected i would like a macro that would sycronise the data from two of the tables and put it into the thereid one. pls some oen help me i have spent hours looking at macros extra trying to do it!!!


tom

 

[ted.martin]

If I understand you correctly, the way to do this would be to write a Delete Query for Table 3; a Make Table Query for table 1 based on new Table 3 and an APPEND query for Table 2 to Table 3. As far as the macro goes, run them in the above sequence. Tables 3 will then me Table 1 records + Table 2 records.

 

[tomlee]

first of all thnks for replaying so quikly
but i do not understand how to do this in delete queris??