Linking Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I use to track projects. I would like to be able to
go in and enter an update including a date and then save it. The next time I
go in I want to be able to add a new update and have the old one. I will
then have a record of all the updates. I throught I could use a seperate
table and then create a subform on he main table but that is not working.

Any Ideas?

Thanks in advance.
 
One way is to add fields like Editor, Rev, and MDate (modified date). Then
copy the record and default MDATE to Now() to set datetime. Make the record
identifier, Editor, Rev, and MDate combination a compound index set to unique.
 
Back
Top