thanks jason, will give it a go.
i am having problems with my data assist search behaviour. i modified the recordset by adding in a where clause as default one created did not have this.
when i test the recordset in dreamweaver it shows the 4 results i expect yet my search and results by data assist is showing all records, i am not sure why it is doing this at all.
any ideas?