Notes field in a Database

[AmyLynnHill]

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.......

 

[neileg]

You need to create a second table that is linked to your existing table by whatever is the primary key in your first table.

You can then manage the data in a form/subform so that all your notes on one policy are shown together and any new notes are automatically attached to the right policy.