Sharepoint Filtered Lookup

[cotton31]

Hi all,

I have a breakdown of tasks in a list with each task assigned a responsible user.

I need users to be able to add current figures for their tasks to another list, however, when creating a new item I only want them to be able to see tasks they are assigned to in a dropdown list.

This is kind of like how a filtered view works, although I want it on a new item dropdown.

Any ideas?

Thanks,

 

[PoD]

Which version of SharePoint are you using as pre 2010 it 'may' be a little more difficult due to the crappy way it insists on storing data at site collection level.

If I understood what you said correctly then you set the item level permissions to 'only there own', create a new custom list with the items you want and add the current figures as a lookup then save it as a 'content type' and it have it open on the new button.

Might be a little more complex than that though, but you dont even need VB or designer to do that

 

[cotton31]

Thanks PoD - I'm using WSS3.

I've actually sorted this now using the FilteredLookup custom field, which allows the drop down items to conform to a list view already created, which I filtered to show only those allocated to [me].

I'm now stuck on another part - my task list contains other information that I would like to pull through to the 'new' item dependent on what I chose in the drop down in my original problem. In essence I want something similar to VLOOKUP in Excel.

FilteredLookup supports CAML queriest to limit the data and I wondered if I could use that, but all examples that I have seen seem to relate to comparing a column to a static value rather than another column.

Thanks for your help,