Table creation question

  • Thread starter Thread starter Timothy Millar
  • Start date Start date
T

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
 
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.
 
Back
Top