Memo entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am fairly new and teaching myself how to use Access. I am using Access to record calls in a small call center. In my table I want to be able to enter multiple notes for 1 record. Is this possible (currently using the memo field so all notes on that one record run together) If so, how? Thanks!!!!!
 
If it were me, I would create another table connecting to
the first table, to hold only the notes. BECAUSE I would
not want duplicate records for each note. Example below:

table1 table2
NoteID <---->NoteID
NameONNote Note
NoteTime

If it were me, that is...
-----Original Message-----
I am fairly new and teaching myself how to use Access. I
Click to expand...
am using Access to record calls in a small call center.
In my table I want to be able to enter multiple notes for
1 record. Is this possible (currently using the memo
field so all notes on that one record run together) If
so, how? Thanks!!!!!
 
Back
Top