So I think I understand but my options recordset that I am trying to use to sort the options list is bringing all options twice. I set my database to have an ItemsOptionID colum in my Items table that matches with the ItemsOptionID column in the Options table so I can associate the two.
I then put in three options in the options table with an ItemsOptionID of 1:
I then set the ItemsOptionID for two individual products to be 1. I attached screenshots of my recordset and how it displays on the test page. Here is what I used on the recordset:
FROM (itemoptions INNER JOIN items ON itemoptions.ItemOptionsID=items.ItemOptionsID)
WHERE itemoptions.ItemOptionsID = items.ItemOptionsID
Thanks again for the help