Populate table with another table values

  • Thread starter Thread starter ABC
  • Start date Start date
A

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
 
-----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
Click to expand...
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
 
Back
Top