1

I have to create a simple Classifieds system in SharePoint. One classified item can have multiple images. Does anyone have suggestions on design for this initiative? For example, should I have a custom list (Classifieds) which will contain a lookup column to an Assets library (ClassifiedPhotos)? Or can a single library item hold multiple images without using a lookup column?

Michael Colbs
  • 3,919
  • 2
  • 48
  • 96

2 Answers2

2

3 approaches:

  1. Lookup Column to the Images library of your preference (the one you suggested)
  2. Attachments in the List Item
  3. Document Set. Basically a Document Set is a type of Item that can have custom fields. It's very particular in that it can hold multiple files, and provides a welcome page that is very useful to quickly see which files are associated with the Document Set. This would be my preference. It has the best of both worlds.

http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-document-sets-HA101782466.aspx

http://technet.microsoft.com/en-us/library/ff603637(v=office.15).aspx

http://office.microsoft.com/en-001/sharepoint-server-help/create-and-configure-a-new-document-set-content-type-HA101782461.aspx

Amadeo Gallardo
  • 1,635
  • 15
  • 25
  • I went with the lookup after. Although I did explore Document sets and they seem useful, are not ideal for my requirements. thanks for the help! – Michael Colbs Apr 10 '14 at 22:17
0

Create a Custom List, 'Classifieds', then an Assets Library, 'Classified Photos'.

In the Assets Library, 'Classified Photos', add a lookup column to point to the Classifieds List.

That way, when you upload an image, you just choose the corresponding Classified

That's the proper way to represent the one-to-many relationship, not by adding the lookup column to the 'Classifieds' List.

Omar Stewey
  • 1,170
  • 1
  • 7
  • 16