I need to store company and contact data in some repository. Not hard at
all of course if I didn't have to connect the records together.
Companies need to be linked to several other companies, contacts need to
be linked to several companies, companies can have multiple contacts, etc.
On top of that I need to be able to
- link documents, meetings, e-mails, tasks, etc. to contacts and/or
companies
- share the contact and company data with Outlook
- link some of the contacts to SPS users
AFAIK there are two possible repositories to use: Sharepoint contact
list or a separate database.
Using a SharePoint Contact List :
How do I represent the contact list data in a nested tree structure? Do
I need to build a template? HOW?
How can I link this list to other SharePoint functionalities and the
User database?
What are the rules on writing to SharePoint lists from a custom application?
On the positive side, the Sharepoint contact list allows me to upload
documents in relation with a specific contact.
Using an external database
How do I connect my external database to the SPS functionalities like
document repositories, user lists, etc.?
I have started building custom WebParts in Visual Studio using an
external database, but this is pretty time consuming (hand code every
form element). This is the reason why I'm looking at faster
alternatives, aka the SharePoint lists. The lists are easy to use and
fully editable. The nesting and different representation of this list is
the big difficulty though.