Re: Filtering list based on lookup records

You can also chain web part connections and have three web parts linked
after each other.

Company then Legal then your final web part

Engelbert

"Gavin" <gavin.dellbridge@xxxxxxxxxxxx> wrote in message
news:1142428662.699483.258730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I currently have two lists one of which contains a list of suppliers
which are split into two categories using a choice field and the other
shows projects which includes a lookup to the suppliers' names.

What I need to do is filter the projects based on the category of the
supplier. IE

List A

Supplier Name Category
Company A Legal
Company B Other
Company C Legal

List B
Project Value Supplier
Project 1 £x Company A
Project 2 £x Company B
Project 3 £x Company C

In this instance I would need to be able to choose "Legal" or "Other"
and therefore return Projects 1 and 3 or Project 2 on its own depending
on the value chosen. I know that web part connections would allow me to
filter list B based on list A but as far as I know I could only filter
based on one company and not all companies having Category="Legal".

Is there a way to do this?

Thanks,
Gavin Dellbridge


.

Relevant Pages

  • Filtering list based on lookup records
    ... I currently have two lists one of which contains a list of suppliers ... which are split into two categories using a choice field and the other ... What I need to do is filter the projects based on the category of the ... Supplier Name Category ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Initial display in a list with web part connections
    ... You can only specify that the first row of the source list in the connection ... filter being applied at all). ... >I have Main List with web part connections to "provide row" to other lists. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: A roguelike system in Perl
    ... >> blank cave. ... >> coordinates with borders. ... > rooms in the lists of coordinates with borders (or have a way to determine ... >> starting from these connections. ...
    (rec.games.roguelike.development)
  • Re: A roguelike system in Perl
    ... > coordinates with borders. ... rooms in the lists of coordinates with borders (or have a way to determine ... and sort their list, trying the ones from the beginning first. ... > starting from these connections. ...
    (rec.games.roguelike.development)
  • Re: web part connections
    ... For the List View Web Part, you are correct: the radio buttons are what they ... then you have the ability to use any view style and fire connections. ... it would be the first tag in the page) and copy the entire block for the ... >> I've created three new lists in WSS site, ...
    (microsoft.public.sharepoint.windowsservices)