keeping a history of data

[Guest]

Being a new user, brought me to this site with a multiple of information, but
unfortunately not my info. I built a database for instruments that needs
calibration. No problem so far. But when I presented it to the user, he told
me he needed to keek a history of the past calibration ( last calibration and
next calibration dates ). I built it with only one table, so whenever the
user puts in new dates it overrides the last ones without keeping them. I
know there must be a way of doing it...

Thanks!

 

[Keith]

Being a new user, brought me to this site with a multiple of information,
but
unfortunately not my info. I built a database for instruments that needs
calibration. No problem so far. But when I presented it to the user, he
told
me he needed to keek a history of the past calibration ( last calibration
and
next calibration dates ). I built it with only one table, so whenever the
user puts in new dates it overrides the last ones without keeping them. I
know there must be a way of doing it...

There is but not at newbie level I'm afraid. You need to use form events in
VB code to identify when a record is updated and record the changes in a
separate table. Post back if you've used code before and I'll take you
though it.

Regards,
Keith.
www.keithwilby.com

 

[Ed Robichaud]

You need a minimum of 2 tables; 1 list of instruments, 1 list of related
calibrations for those instruments.

tblInstruments
InstrumentID - autonumber primary key
InstName
etc.

tblCalibrations
CalibrationID - autonumber primary key
InstrumentID - foreign key (related to tblInstruments)
CalDate
etc.

Create your tables, define the relationship ( 1- many) and then create a
form (and subform) for data entry.
-Ed

 

[Guest]

Thank you! That's exactly what I was looking for..:->