thanks dani, it then needs to display a recordset(table) on the page based on that criteria.
what if i had it 2 seperate pages, one called "products_sold.php" & "products_not_sold.php"
how could i have a drop down list that when they click on one product name it shows everyone that does not have that product?
what would the recordset queries be for that result?
ideally would like to do it the first way but you can let me know i would appreciate it.
thank you