Filtered Lookups? 1

[Wootoid]

I am trying to create a few lookup columns that only display data from an associated view, not the entire list. Basically I want the lookup to drop down only values associated with the current user when the user creates a new item.

Does anyone know if this is possible, or am I stuck with viewing all items?

Thanks in advance.

Aren

 

[vbkris]

>>Does anyone know if this is possible, or am I stuck with viewing all items?

yes you are stuck if you want to stay with default MOSS UI.

you do have the following workarounds (in order of preference):
a. Derived / Calculated Columns - See if you can create a dervied column in your lookup list based on created by. If you can you can set this as the lookup field in the referring list.

b. Create a custom UI for your form - Complete control over UI

c. JavaScript - You have to write custom JS that can be used to manipulate UI elements (such as removing values from a dropdown etc).




Known is handfull, Unknown is worldfull

 

[chrisbarba]

You could do this with a user control that reads/filters the list.

That's going to require a new discussion.

Chris

http://chrisbarba.wordpress.com

 

[ooloo88]

It is definitely possible, yet you need to code it or add some third party tools like SharePoint Cascaded Lookup.

If you want to get your hand dirty, I hihgly recommend you to take a look at MSDN and search BUILDING PARENT CHILD RELATIONSHIP LOOKUP COLUMN, there are lot of such discussions if my memoory serves me well.
Hope this helps you a bit!