OLE or Memo

[Greyowlsl]

Hi,

Ive got a form that has Customer infomation.
Basicly i select a customer from a combo box and it loads up their record.

What i require is that when i open a customers record, that i can enter alot of info about the meetings i have with them.

My first solution was to make a new table with a memo(s) fields that i would just link to.

But i read in MS help that an OLE object would be better. How would this work.

Mind you there are over 100 customers, and other staff will be using this system aswell.

Thanks for you time.

 

[CJ_London]

I'd stick with the memo field - ole objects might be a file like a word or excel document, a picture etc.

If you wanted to go the ole route then suggest create a word document and link it to the ole field. Then you would update the word document with your various conversations etc. Or you would create new documents for each conversation. Either way, unless you want the word features for tabbing, indenting, inserting pictures, etc it is a lot more work