Paul Giesenhagen wrote: > You could create a database like this: > > ID|USERID|SONGID > 1 1 222 > 2 1 443 > 3 1 9494 > 4 2 999 > 5 2 443 etc...
Leave out the ID field and use a composite primary key on both userid and songid. Add a constraint that limits the amount of occurences of a userid to 40 and you are set to go. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
