> > I need to become more familiar with using unique constraints, etc
Yes you do! Do it now and save yourself pain later ;) Relying on a primary key to make a table row unique invariably leads to duplicate data (even though they have unique keys) which is a royal PITA. As a general rule, every table should have a primary key and at least one unique constraint, i.e. every row in any table should be unique regardless of the PK and the db can enforce that for you with unique constraints. Say goodbye to duplicate data today! :p Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
