lets try this.... productTable pId, acList 1.............3,5,7 2.............2,3
accessoryTable aID, Products 2.............1,2,3 3.............3,4 5.............2 7.............12,15, et.. the user basically selects aa aid from the accessories table in the form of a check box. and ascociates as many id's containg producta [which are accesories] to what ever real product he wants.. this really does seem to work quite well. all my code seems fine now. thanks to that valueList thing... i was just trying to clean up the result sets... WHERE aId IN (#accList#) works... accList: <cfoutput>#ListSort(accList, "Numeric")#</cfoutput><br /> shows accList: 132,132,135,135,136,136,136,136 i was just trying to look through all the stabndard functions out there to remove duplicates. listToArray throws me a error converting simple something to something... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4