I think it's time to add a Recordset behavior to DataAssist. The built in one with Dreamweaver has always been limited. Here are a few features that would be nice:
1. Extend the simple mode to include more than one filtering parameter, and be able to choose AND and OR
2. A Dynamic option when entering the variable/value for the filter - such as being able to select a session variable rather than trying to remember what it's called, exiting out of the dialog to find it.
3. And in the same section, be able to enter a result from a previous recordset. This would only work if the recordset that supplied the data came first, so it may have to reorder them. I've done this manually several times and it's a pain - not so much in entering the code for the Field value, but you get errors when the value is null.