Ok, thanks for the links, it clears up a bit. The problem is that in the db items with different options are listed each as a unique item. In order to show only one option you will need to limit the products being returned to only the first option. Since the regular results page recordset does this for you it might be a good idea to start with the same sql as that recordset and just modify it to fit your needs. As you can tell by looking at the recordset on the results page it is a fairly complex query and has to account for quite a bit to get the records to show like they do.