Using SharePoint HTML Forms to filter a list

In a previous post I set up an external list onto my SharePoint site. I now want to be able to filter the results based on a users input on a form. There are two ways of doing this:

1. Simple SharePoint HTML forms. 
2. InfoPath forms published to SharePoint.

In this post I will be concentrating on method 1. In a future post I will do post 2 (I hope).

Ok, so I have a list (external in my case) and this is on a page.

1. Turn editing on -> on the same page as the external list.
2. Add a new web part: Under Categories select Forms. And then select 'HTML Form Web Part'. 
3. When the web part has been added click on the usual edit drop down arrow to the top right hand corner of the web part
4. Select 'Connections' -> 'Provide Form Values To' and then select the List/Web part that we are filtering
5. Click on 'Configure Connection'
6. Select the field from the 'Consumer Field Name' that matches the field you want to filter the data on.
7. Press finish and it will now work as a filter. 

Notes:
The filter is only filtering on the list below, not the actual query that is being sent to the data source. In my situation the data source is an external SQL server. This, by default, gets back all records from a specific table and limited to 1999 (the default max limit). The form added above filter on these 1999 returned records, not the original dataset from the database.

I have just left the standard text field on the form. You can add other options to the form however you can only connect one field to a list. You can connect multiple lists using multiple fields.