Unclear on Design

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

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