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.