Form For Entering Data Advise Please

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

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?
 
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.
 
Hi Rick
Thanks for the help
I will have a look at the template you mentioned.
Regards
Dermot
 
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
 
Back
Top