Unclear on Design

I am looking to have a form with a problem listed. In this form I would like
there to be a subform that lists the notes by a user that enters data via a
text box.

IE. 9/5/08 Customer Called,
9/6/08 Replacement sent to customer etc.

Questions a
1. How does this work as each record could have multiple entries in relation
to a table that is bound to the subform? (not sure if this is correct?)
2. What if there is more entries on the same day how do I append the notes?

You use two tables in a one-to-many relationship like parent-childern.
The parent table (Trouble call) needs a primary key, usually an autonumber,
to set the relationship to the children table (notes) foreign key that is a
number - long integer..
The form/subform has Master/Child link set on the primary key/foreign key.
The notes table would have a datetime field for date-time. To add a new
note you just type in the blank record that the datasheet view that the
subform presents.
--
KARL DEWEY
Build a little - Test a little


"Rpettis31" wrote:

I am looking to have a form with a problem listed. In this form I would like
there to be a subform that lists the notes by a user that enters data via a
text box.

IE. 9/5/08 Customer Called,
9/6/08 Replacement sent to customer etc.

Questions a
1. How does this work as each record could have multiple entries in relation
to a table that is bound to the subform? (not sure if this is correct?)
2. What if there is more entries on the same day how do I append the notes?