Table creation question

[Timothy Millar]

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

 

[boblarson]

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.

 

[Steve]

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