SharePoint - filter a column in OOB SharePoint

I have a MOSS 2007 server.  I'm trying to create a custom list that filters options using only OOB SharePoint.  I also have access to the entire suite of Bamboo web parts.

I want to filter a list based on a column - so that if a user selects an option from column A, only valid entries will appear in column b.  

For example, if I want to associate users (column A) with work types (column B), Joe can do Database, Networking and Security while Paul can do Web Dev, Admin, and Security.  If a user selects Joe, they should only see the options for selecting the values from column B associated with Joe.  These will all be "choice" column types, but I can't find any way to do it without touching the code.
armyjackAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
this is known as a cascading drop down and there are no OOB filters in sharepoint that do this.

it's possible that the Filter Collection at Bamboo will do this, but their descriptions aren't very in-depth so it's hard to say.  my guess would be that it can't do a cascading drop down.

you can create your own solution or use one that's available on the web (for free):
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

or buy a solution:
http://www.kwizcom.com/ProductPage.asp?ProductID=709&ProductSubNodeID=710

i know you said you want OOB sharepoint or Bamboo.  if that's the case, then the answer to your question is:  No, you can't do it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aspeharCommented:
I think you could achieve what you are looking for by doing an InfoPath form. If you're on MOSS the integration of InfoPath web forms is pretty easy using the form library. You can read more here:
http://office.microsoft.com/en-us/infopath/HP010968041033.aspx
 
0
zephyr_hex (Megan)DeveloperCommented:
ahh yes.  i always forget infopath.

here's the steps for creating a cascading drop down in infopath:
http://office.microsoft.com/en-us/infopath/HA011177131033.aspx

i'm not sure if you consider that OOB Sharepoint or not...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.