In a SharePoint WSS 3.0 site two linked lists eg Project and Tasks. New tasks can only be assigned to open projects. Therefore in the new tasks form I need to filter the project drop down list to display only projects with a 'Status' equal to 'Open'.
Following these instructions in SharePoint Designer I have:
- Created a new form
- Inserted the 'Tasks' custom list form
- Created the filtered 'Project' data source and added it to the form
- replaced the link field dropdown list with:
<SharePoint:DVDropDownList runat="server" ID="ff3{$Pos}" FieldName="Work_x0020_Pack_x0020_No_x002e_" DataSourceID="Filter" DataValueField="Work_x0020_Pack_x0020_No_x002e_" selectedvalue="{@WPN}" __designer:bind="{ddwrt:DataBind('i',concat('ff3',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@WPN')}" />
('Work_x0020_Pack_x0020_No_x002e_' is the name of the field in the filtered lookup and 'WPN' is the name of the field in the form.)
The drop down list contains the correct filtered data but when the form is submitted the 'WPN' field contain no data. Presumably the drop down list is not linked to the form correctly.