Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How to achieve nested lists in SP

  Asked By: Ramon    Date: Oct 23    Category: Sharepoint    Views: 10583

I'm looking to utilize nested lists for the following scenario. Any
experiences/ideas appreciated:

I have multiple Widgets.

For each Widget, there is a group of 40 or so Wackadoos.

For each of the Wackadoos, there is a consistent set of attributes for
which I need to track values, such as overall status, comments, etc.

Example:

Widget 1

Wackadoo 1

Status

Comment

Action Item

Etc.

Wackadoo 2

Status

Comment

Action Item

Etc

I'd like to setup my list entry so that my users can enter information
for new or existing widget, where they can enter and see each of the 40
Wackadoos for that widget in one form (Also one click to create this new
entry instead of 40 clicks.) To do this, the only way I can see to do
it is to use nested lists - especially for data entry, - however, I
haven't found a mechanism to achieve nested lists.

I've mapped out lists. Elements and element attributes will have their
own list. Wackadoos and Widgets will have their own lists as well to
enforce integrity.

Is there a way to nest/group lists.

Share: 

 

8 Answers Found

 
Answer #1    Answered By: Jose Scott     Answered On: Oct 23

No nice way to do this.

One of my top three platform busters is a lack of relational list
support. Data entry  for this scenario  is really lousy. InfoPath can help
but the reason that you probably went with SharePoint is that the data
entry forms are dynamically created and maintained by the end user.

 
Answer #2    Answered By: Taylor Clark     Answered On: Oct 23

If nested  lists are not realistic, I am toying with a backup plan of
using the 'edit in datasheet' mode - with user filtering on a given
Widget - to simulate true nested lists. This would be our data  entry
form.

In order to make this workaround feasible, I need a mechanism  to create
an list  record for each Wackadoo for a given Widget - so my user doesn't
have to create  40 new items for each new widget.

Can workflow be used for this purpose? e.g. Enter a new widget in the
Widget list, and the 40 Wackadoos will be auto created - using the
Wackadoo list - in the Widget Wackadoo list.

 
Answer #3    Answered By: Anthony Rutledge     Answered On: Oct 23

There is this project out there, but I haven't seen much activity yet:
http://www.codeplex.com/SharePointSubTasks

I created a workflow that created several other items in different lists
using SharePoint designer. It was a pretty simple scenario  and,
therefore, a fairly simple solution.

 
Answer #4    Answered By: Heena Nagori     Answered On: Oct 23

Seriously, SharePoint lists  are not currently built to support
normalization and relationships. That's what you really want. The
easiest way to do this would be to write a set  of custom webparts that
talk to a back end relational database. I've done this on several
projects and although it requires a little coding it is much better than
trying to trick SharePoint into doing something that looks like its
relational when it isn't.

 
Answer #5    Answered By: Aishwarya Karmarkar     Answered On: Oct 23

You've hit the nail on the head. What I really desire is a relational
model, with SP as my interface - a stopgap solution. My issue now isn't
so much how to store it relationally - I think I've got that figured out
in SP, kludge and all, - but how to make the user interface work like I
thought it could; As a grid. For someone with lots of data-modeling,
and some coding - vb, javascript 5+ yrs ago, what would 'a little
coding' entail, and might it - webparts - allow me to create  the entry
grid I desire? BTW, most likely db in this instance would have to be
Access.

 
Answer #6    Answered By: Janell Camacho     Answered On: Oct 23

I would suggest you to take a look at Bamboo Solution's list  Integrity web part.

store.bamboosolutions.com/...-part-release-20.aspx

Though not equal to relational entirely, this web part can build Primary
Key-Foreign Key relationship between 2 lists.

 
Answer #7    Answered By: Julia Washington     Answered On: Oct 23

What you are suggesting is VERY doable; in fact, I don't understand why a much
larger proportion of Sharepoint solutions aren't built this way--as a collection
of web parts which address a separate relational database.

There are two issues here:

1) The philosophy: using a relational database for complex functionality, and
Sharepoint lists  for less complex functionality and integrating with specific
Sharepoint features. I would incline towards 80/20 for using a relational
database for any functionality that is sufficiently complex.

2) The logistics of coding web parts with all of the available ASP.NET controls
when a presentation layer isn't available. It's a bit of a learning curve at
first, but once learned, it is quite doable, and also, MUCH faster because the
entire web part is precompiled. You asked about GridView; below is a code sample
which binds a datasource to a GridView within a web part. I am showing a subset
of the code where I am grouping controls within a panel, in this case, a Label
followed by an SPGridView. Elsewhere in the code is the event handlers, etc.

 
Answer #8    Answered By: Rashmi Bhimani     Answered On: Jul 23

Have a look at below link:
www.codeproject.com/KB/XML/NestedListSP.aspx

you can add Dataformwebpart to Edit, New and Disp forms of master/parent list.

 
Didn't find what you were looking for? Find more on How to achieve nested lists in SP Or get search suggestion and latest updates.




Tagged: