Ok... I see where you are going. But it has created another issue.
Based on what you said, heres what I did. I went in and added 3 columns to the options table. The first one is called categoryID (b/c on the products table the large bag is productID #1 and #2 is the small one. So for all the colors that would correspond with that handbag, I just entered that products number. Then when in the recordset I can filter by that productsID with the value contains setting.
I also added a column for each bags sort order. B/c I need them to appear in an order that matches a color swatch that customers can rollover to change the color of said bag. I figured I could use the sort option within the recordset to accomplish this.
Ok... so heres where the other problem comes in. So I built my recordset based on the "Product Options for eCart" tutorial. Remember I skipped over anything size related. But still entered all the coding for the rsColor along with the variable. (I'm guessing this code somehow bridges the ProductOptions table and the Options table... but i'm still unsure what this code actually means) So with that being said, within the advanced tab of the rsColor recordset I have no options for selecting the filter option or sort option as you would within the simple view.
Is this code necessary or do I just need to add something to it?
Thanks so much for your help!