making values post oldest to newest

[seanw]

I'm currently building a system that tracks healthcare information. The MDs enter data on one form for current data then it needs to populate a second form that maintains a historical record, oldest to newest so the MDs can view a record of values. The problem is that when we enter data on the "current" form, it overwrites the information on the historical record and doesn't maintain all the values entered. Is their an easy, pre made script that I'm overlooking for this? So basically, current information needs to display in one spot, and a historical record in another. IF anybody has ideas, I'd love to hear them!

[Vaughan]

Lookups are good for this, as opposed to related fields.