Notes field in a Database

AmyLynnHill

Registered User.
Local time
Today, 04:27
Joined
Dec 7, 2005
Messages
81
I have a database housing insurance policies, agents and groups(schools that have the policies). Currently, we call groups and put a "note" on a policy. This is a very basic database. I created a field called "notes". The callenge I have with this field is that only one note can be contained. Therefore, if we call several times the dates and note information all go to the same field. Any suggestions on setting up some type of table that would allow multiple note fields? how would I link the table to the main information table?or another approach? Any suggestions would be helpful.......
 

Users who are viewing this thread

Back
Top Bottom