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.