Hi Ryan, Maybe I'm oversimplifying, but why do you need two temp tables? If you're just bringing results back with a SELECT query, it seems you'd just have to construct your query to return one or two resultsets which you could then merge into one if needed.
Then again, maybe a graphical representation would be in order. Do these checkboxes have text inputs? Again, it sounds like you could do this with two select queries (or even just one)... Cheers, Peter From: Ryan Olshan [EMAIL PROTECTED] I am working on a report that has 2 DropDownLists. Each DropDownList contains the same Status Codes. Then below the Status Code DropDownLists is a CheckBoxList that is populated with items that represent fields to search in the same database table. Based upon that, the search result needs to return groups of results where each group contains a list of ID's where there are possible matches found between the database fields checked off in the CheckBoxList and the selected Status Codes in the DropDownLists. I understand that I need to have a scoring system and two temporary tables. The problem I am having is getting the scoring system to work and returning the grouped results. -- Thank you, Ryan Olshan TeraNet Systems http://www.teranetsystems.com [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
