Filtering list based on lookup records

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

  • RE: Requery data on subform
    ... My problem was that requerying my combo was leaving the value stored in it - ... To put it more plainly the main form is suppliers, the combo box lists the ... ranges that the supplier has - so change the supplier and the list of ranges ...
    (microsoft.public.access.formscoding)
  • Re: Variable list of values in column
    ... SQL Server Programmer ... "Kirk Graves" wrote in message ... It is also desirable to construct searches over projects>> that contain a supplier or part. ... >> does I ensure the lists in the project table are updated. ...
    (microsoft.public.sqlserver.programming)
  • Re: Filtering list based on lookup records
    ... You can also chain web part connections and have three web parts linked ... I currently have two lists one of which contains a list of suppliers ... What I need to do is filter the projects based on the category of the ... Supplier Name Category ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Variable list of values in column
    ... The data structure you need would actually look like this ... Fields: PartID ... > that contain a supplier or part. ... > does I ensure the lists in the project table are updated. ...
    (microsoft.public.sqlserver.programming)
  • Wanted: Wholesalers and Marketing Reps
    ... goods online at eBay for twice the price. ... just you and the supplier - and you need no money down. ... We supply over 3000 lists per week, we update our lists daily so there are ... Go to the link list below, type in ONE of the voucher numbers listed beneath ...
    (uk.jobs.fortyplus)