I have a Sharepoint 2007 site and want to create a list that users can filter dynamically using a form or something similar. The use case is as follows:
- A user is shown a list with any number of items. The list itself includes a data column to be used by the filter form.
- The user uses a filter form with a drop-down selector bound to select what items they want to see, or default to show all.
- After selecting the items to filter, the items they picked to display are shown.
I added a form web part to the list page, but I'm not sure how to add drop-down elements to it, can I add drop-downs using the source editor? If so, how can I specify the lookup columns for these drop-down selectors?