Re: Can I do this with a SharePoint list?
From: Edward Lee (elee_at_ulgm.org)
Date: 05/04/04
- Next message: Jorge Luis Prado López: "Hi"
- Previous message: anth007: "Webpart to share same data to other webparts on different pages"
- In reply to: Steven Collier [MVP]: "Re: Can I do this with a SharePoint list?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 3 May 2004 22:26:48 -0500
Steven,
Can you elaborate on part 2 of your response below. Part one was pretty
clear. I created two lists. List 1 has a field called 'Name' and List 2 has
a field called 'Date', 'Hours Volunteered', and 'Name'. The 'Name' field in
List 2 is a lookup column that draws its values from the Name field in List
1. I'm not entirely clear on step two. Can you tell me more?
Thanks,
Ed Lee
"Steven Collier [MVP]" <steven.collier@mvps.org> wrote in message
news:ezRVEMuLEHA.1388@TK2MSFTNGP09.phx.gbl...
> You can nearly do it, there's just one link missing that breaks the whole
> thing :-
>
> 1. You can add a column of type lookup which is a link between tables (it
> stores a row number but displays the value from the column in the second
> list you select)
>
> 2. You can use webpart collection so when you select a row in list one,
list
> 2 filters to show rows that match.
>
> But what's missing is that it currently prevents you from using these
lookup
> columns in connections, so the who lot is useless.
>
> It's quite possible to create what you wanted by building some custom
> webparts etc. but it would be much nicer if it could be done with features
> in the box
>
> --
> Steven Collier
>
> SharePoint Portal Server MVP
> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> news:u3BXNTtLEHA.624@TK2MSFTNGP11.phx.gbl...
> > Pity it's you who is asking Ed otherwise it would be a simple "I
wouldn't
> > start here" I.e. I wouldn't use WSS for this.
> >
> > But with your skills you are bound to be able to get it to work - it's
> > really as I see it a question of whether the ease of creating the web
site
> > and the demographic info outweighs the messing around to get the rest.
> >
> > I'd say no, but that's a gut feeling only.
> >
> > Mike Walsh, Helsinki, Finland
> > WSS FAQ at wss.collutions.com
> > Please post questions to the newsgroup only.
> >
> >
> > "Edward Lee" <elee@ulgm.org> wrote in message
> > news:#9OKBDtLEHA.1052@TK2MSFTNGP12.phx.gbl...
> > > I'm wondering if I can easily accomplish the following with a
SharePoint
> > > list, or whether I should be considering an Access database or some
> other
> > > solution...
> > >
> > > We need to keep track of about 300 volunteers. Along with demographic
> > > information, we need to keep track of their site assignments, each of
> > their
> > > volunteer sessions, and the amount of time volunteered during each
> > session.
> > > I would then need reports on total number of hours volunteered across
> the
> > > entire project and by site for various periods of time.
> > >
> > > I guess the big question that I have is whether I can create, what in
> > > database terms would be, a one-to-many relationship. That is, each
> > > individual volunteer record is associated with many volunteer session
> > > records.
> > >
> > > Thanks for any advice,
> > > Ed Lee
> > >
> > >
> >
> >
>
>
- Next message: Jorge Luis Prado López: "Hi"
- Previous message: anth007: "Webpart to share same data to other webparts on different pages"
- In reply to: Steven Collier [MVP]: "Re: Can I do this with a SharePoint list?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
