i am thinking now that i should have only a single recordset for the products and somehow write the sql filtered so that the list/menu will only show the color choices of the item shown.
i have tried variations of this sql
FROM items INNER JOIN color_lookup ON color_lookup.item_colorID = items.item_colorID INNER JOIN colors ON colors.color_ID = color_lookup.color_ID
WHERE items.itemCatID = 3
ORDER BY items.itemName
but can't get it to show only 1 item and only the colors for that item.