Populate table with another table values

[ABC]

Hi all,
I have two tables(main and result) with two fields(ID,
Result) in common. The main table is updated through the
front end. The result table i want it to get populate with
the values from the main table and also the this table has
a date field which i would like to get updated to today's
date everytime this table is updated with the new values.

thanks for the help in advance...
thanks
ABC

 

[Larry]

-----Original Message-----
Hi all,
I have two tables(main and result) with two fields(ID,
Result) in common. The main table is updated through the
front end. The result table i want it to get populate with
the values from the main table and also the this table has
a date field which i would like to get updated to today's
date everytime this table is updated with the new values.

thanks for the help in advance...
thanks
ABC
.
Create an append query using the main table to the

results table. In the results table set the default value
of the date field to =date(). Everytime the results are
appended to the current date will be inserted in the record