Table creation question

I have a database that I use to track boxes. Each record is a single box as
each record could contain multiple bits of information that pretain to just
that box. My question is; each record has a memo field for notes. These
notes are entered in during the coarse of the life of this box which mean
that I can have as little as a single note or as many as fifty notes per box.
What would be the best way to maintain this information as I need to
time/date stamp each new note entry?

Thank you for your help

I would create a separate table for notes and use the other table's primary
key as the foreign key within the notes table and then use a subform to enter
as many notes as needed.
--
Bob Larson
Free MS Access Tutorials and Samples at http://www.btabdevelopment.com

__________________________________


"Timothy Millar" wrote:

I have a database that I use to track boxes. Each record is a single box as
each record could contain multiple bits of information that pretain to just
that box. My question is; each record has a memo field for notes. These
notes are entered in during the coarse of the life of this box which mean
that I can have as little as a single note or as many as fifty notes per box.
What would be the best way to maintain this information as I need to
time/date stamp each new note entry?

Thank you for your help

What do you mean by:
"....each record could contain multiple bits of information....."?

If you are recording something like the contents of the box, then you
shouldn't be recprding this data in notes. Rather you should have a separate
table. Your tables would look like:

TblBox
BoxID
Descriptive fields about the box

TblBoxContent
BoxContentID
BoxID
Descriptive field about the item in the box

Steve


"Timothy Millar" wrote in message
...
I have a database that I use to track boxes. Each record is a single box
as
each record could contain multiple bits of information that pretain to
just
that box. My question is; each record has a memo field for notes. These
notes are entered in during the coarse of the life of this box which mean
that I can have as little as a single note or as many as fifty notes per
box.
What would be the best way to maintain this information as I need to
time/date stamp each new note entry?

Thank you for your help