Hi I think the problem is here:
>>Store the item in a single delimited field in the Contact table using matching numbers 0 - 10 for easy repopulation to the page. You may want to reconsider how 'easy' this is making the repopulation to the page. Perhaps a joining table could help - something like: ContactPK RaceID 1 -------------- 1 1 -------------- 8 2 -------------- 0 3 -------------- 5 3 -------------- 7 Or, you could write a function that takes your list of raceIDs (eg 1,8) and returns a string into your select statement (eg Caucasion, Native People). If you go down that route, search the archives of this list for a function by Neil R-R called listToTable (I think). HTH Antony <snip> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2546 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
