"JohS" wrote in message
. ..
Hi. I'm planning to build a CRM system - any who know if there are any
samples out there?
(I'm specially interested in the structure of key fields).

There are many examples, e.g. MS has a template for contacts in Access 2007.

There are 38 sample structures for handling customers he
http://www.databaseanswers.com/data_models/index.htm

If your needs are simple/standard, it will be easier to use an off-the-shelf
solution, starting with MS Outlook (shared and personal contacts and
calendar schedules) and moving up to more expensive ones.

If you need to handle corporate entities (companies, organizations,
households) as well as individuals, then one of the issues you face is how
to tie persons together into such groupings. This article has some ideas on
that:
People in households and companies - Modeling human relationships
at:
http://allenbrowne.com/AppHuman.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.