Form For Entering Data Advise Please

[Guest]

I have a Flat table database....
I have about 20 fields of data, the last field being Notes (Memo)
I created a form to enter date into the table.
Put a command button on the form, to enter another record.
I only want one entry for each client, being able to update only the Notes
after each call phone call
What is the best way to update only the notes.
Should I really be using related table.....Notes being a separate table as
each client can call several times.
If so how would I split this flat table now that I have put data in it....do
I have to start again?
Hpoe I haven't confused....looking for the best way I should have approached
this task?

 

[Rick B]

Normally, you would store your phone contacts in a separate table. This is
a classic one-to-many relationship.

You ought to look at the contact management database template that Microsoft
provides. I have used it as a starting place for several projects.

It lets you log each contact as a separate entry and include the time and
date of the contact, notes, etc.

 

[Guest]

Hi Rick
Thanks for the help
I will have a look at the template you mentioned.
Regards
Dermot

 

[Guest]

Quote
You ought to look at the contact management database template
Thanks for bringing this to my attention Rick,
As you say, it serve a pupose similar to what I am looking for, it make much
more ense to use the separate tables, to achieve what I want.
Best wishes
Dermot