Creating a status log in Access Forms

  • Thread starter Thread starter Stacie
  • Start date Start date
S

Stacie

I've created databases in Access before, and I know that
what I'm asking is probably a very simple procedure, but I
really don't know how to do it.

What I need to do is create a database that tracks the
status of contracts. At the top of the form, all the
pertinent information about the contract will be shown,
but then I'd like to have a set in table (for lack of a
better description) that has one row in it, and the first
cell will be a date, and the next cell will be a
description. For instance, the line might read:

6/25/04 Contract received partially executed.

Then each time I need to update the status of the
contract, I can just add a new row above the exisiting
rows, type in the date, etc...

Any help is greatly appreciated.

Thanks again!
Stacie
 
Sounds like you need two related tables: Contracts and ContractStatus,
related, say, by the Contract number.

Then you create a form for Contracts, and a subform for your status
information.

Does that help?

grep
 
Back
Top