History Table

[Guest]

I'm building a databse that tracks the progress of business opportunities.

I have set up a history sub table for each opportunity in which the user can
enter data manually.

Each entry occupies a separate row with a field for detail and a field for
date.

What I also want to do is to automatically update the history with date and
new status on the sub table as well when the status changes from one stage to
another.

So how do I automatically write data from one table to another.

I'm guesing it's in the "on update" action of the status in my main form,
but I'm not sure what I have to do from there.

 

[Rick B]

Why put it in a separate table? Yust add a "history" check box or a
"inactive" checkbox.

Then, you can include or exclude items where needed.