Sort of, you certainly could do it that way, but I think it would be less 
flexible and harder to maintain. If you did it that way every time you added a 
new contact you would then need to go back to the suppliers list and add them 
to the appropriate supplier.

If you add the lookup column to the contacts list, when you add a contact to 
the list you specify what supplier they are for at the same time as the rest of 
the data. Then you also have the ability to create views that use the supplier 
field on the contacts list (All contacts grouped by supplier, all the contacts 
for supplier X, All contacts in state X grouped by supplier, etc).

Brian Farnhill
L2 Consultant
Technical Consulting

Mobile:   0408 289 303
Fax:      02 8001 7778
Email:    [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
Web:     www.uniqueworld.net<http://www.uniqueworld.net>
Blog:     pointstoshare.spaces.live.com<http://pointstoshare.spaces.live.com/>

[cid:image001.jpg@01C8F2F9.A3FBDD30]

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FILMALTER Arno
Sent: Thursday, 31 July 2008 10:17 AM
To: listserver@ozMOSS.com
Subject: RE: [OzMOSS] RE: Structuring Data in MOSS

That's what I was thinking, separating the data entities and creating a list 
for each entity and then linking them together.
Basically the same as designing tables but only using lists and content types 
instead.

Suppliers List has lookup field to Supplier Contacts List with multiple 
selections allowed.

Does that sound right?


________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Farnhill
Sent: Thursday, 31 July 2008 10:02 AM
To: listserver@ozMOSS.com
Subject: [OzMOSS] RE: Structuring Data in MOSS

In my opinion it depends on how you are going to use the data once you have 
recorded it. Think about what the requirements are for how you plan to use the 
data and that should help you figure out how you should store it.

If you want it is possible to break it up into different lists, one that has 
the suppliers, and one that has all the contacts and this list could have a 
look up field back to the supplier list to identify what supplier they are tied 
to. Then you could filter the contacts list per supplier to see a list of all 
contacts for a supplier, or show them grouped by supplier, or see all the 
contacts for all suppliers in each state (if you have a field for state), etc 
etc etc.

Brian Farnhill
L2 Consultant
Technical Consulting

Mobile:   0408 289 303
Fax:      02 8001 7778
Email:    [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
Web:     www.uniqueworld.net<http://www.uniqueworld.net>
Blog:     pointstoshare.spaces.live.com<http://pointstoshare.spaces.live.com/>
[cid:image001.jpg@01C8F2F9.A3FBDD30]

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FILMALTER Arno
Sent: Thursday, 31 July 2008 9:42 AM
To: listserver@ozMOSS.com
Subject: [OzMOSS] Structuring Data in MOSS

Hi Everyone

This is just a question of best practices a guess...

If I have data like supplier information which I need to capture in MOSS,
do I use normal database design principles to outline the columns and types 
within MOSS or
do I just add the required fields into one list or content type?

Example:
A supplier has name, telno, address ect.
But also has Contacts associated to them.

With normal database design you will separate the two because it has a one to 
many relationship between suppliers and supplier contacts.
But in MOSS you may add these contacts with their detail in one multi line 
field within the list or content type.

Is there any article or blog that discusses this? My personal opinion is to go 
with the traditional database design principles.

I would really want to know what's been done out there.

Regards
Arno

***************************** Disclaimer *****************************

The contents of this electronic message and any attachments are intended only 
for the addressee and may contain privileged or confidential information. They 
may only be used for the purposes for which they were supplied. If you are not 
the addressee, you are notified that any transmission, distribution, 
downloading, printing or photocopying of the contents of this message or 
attachments is strictly prohibited. The privilege of confidentiality attached 
to this message and attachments is not waived, lost or destroyed by reason of 
mistaken delivery to you. If you receive this message in error please notify 
the sender by return e-mail or telephone.

Please note: the Department of Public Works carries out automatic software 
scanning, filtering and blocking of E-mails and attachments (including emails 
of a personal nature) for detection of viruses, malicious code, SPAM, 
executable programs or content it deems unacceptable. All reasonable 
precautions will be taken to respect the privacy of individuals as outlined in 
the DPW Privacy Plan. Personal information will only be used for official 
purposes, e.g. monitoring Departmental Personnel's compliance with Departmental 
Policies. Personal information will not be divulged or disclosed to others, 
unless as required by Departmental Policy and/or State or Commonwealth Law.

Thank you.
------------------------------------------------------------------- OzMOSS.com 
- to unsubscribe from this list, send a message back to the list with 
'unsubscribe' as the subject.
Powered by mailenable.com

***************************** Disclaimer *****************************

The contents of this electronic message and any attachments are intended only 
for the addressee and may contain privileged or confidential information. They 
may only be used for the purposes for which they were supplied. If you are not 
the addressee, you are notified that any transmission, distribution, 
downloading, printing or photocopying of the contents of this message or 
attachments is strictly prohibited. The privilege of confidentiality attached 
to this message and attachments is not waived, lost or destroyed by reason of 
mistaken delivery to you. If you receive this message in error please notify 
the sender by return e-mail or telephone.

Please note: the Department of Public Works carries out automatic software 
scanning, filtering and blocking of E-mails and attachments (including emails 
of a personal nature) for detection of viruses, malicious code, SPAM, 
executable programs or content it deems unacceptable. All reasonable 
precautions will be taken to respect the privacy of individuals as outlined in 
the DPW Privacy Plan. Personal information will only be used for official 
purposes, e.g. monitoring Departmental Personnel's compliance with Departmental 
Policies. Personal information will not be divulged or disclosed to others, 
unless as required by Departmental Policy and/or State or Commonwealth Law.

Thank you.
------------------------------------------------------------------- OzMOSS.com 
- to unsubscribe from this list, send a message back to the list with 
'unsubscribe' as the subject.
Powered by mailenable.com 
------------------------------------------------------------------- OzMOSS.com 
- to unsubscribe from this list, send a message back to the list with 
'unsubscribe' as the subject.
Powered by mailenable.com



------------------------------------------------------------------- OzMOSS.com 
- to unsubscribe from this list, send a message back to the list with 
'unsubscribe' as the subject.

Powered by mailenable.com

<<inline: image001.jpg>>

Reply via email to