Best way to handle notes...

[RickDB]

Hello,

What is the best way to handle notes on a form?

The DB is for recording Quotes and Orders taken over the phone.

Is it best to have a seperate table w/ a NotesType field so that all notes are stored in a central location? Or is it better to store notes for each quote/order in the Orders / Quotes table itself?

Also, if data is entered into these fields using subforms, is it possible to have the notes displayed outside of the subform in a box format, to allow plenty of typing room?

If anyone has a good example of a smart notes system implementaion, it would be very appreciated.

Thanks!

 

[RickDB]

Pat, as always... Thanks!!!

I'll look into the VBA behind the Shift-f2, and build a notes structure into a sample and post sometime soon.

(Hopefully I'll be able to post a decent working database in the next few days)