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,

 

[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,