> > I am assuming that you mean that a user can create a top10 list or any or > all of the other tables. > Yes exactly - at first I had it exactly this way, a single extra join table per entity that was to contain the user's top items. It then dawned on me that this was limited to describing only one sort of list (top x ys) so I added the complexity by enabling the user to have many different lists per entity so:
Songs that always make me cry... My favourite shower songs.. etc I started this by creating a single generic 'List' table that has userID, title and description. In each of my "Top[entity]' tables, I ditched the userID for the listID. This is fine if you want to find the list details when you have the list item, but finding a list item from a list ID becomes more difficult as it could be in one of a number of tables. So I am coming to the conclusion that I need a list table for each entity as well as a list item table for each entity. Unless I am missing a trick completely(?) Dominic ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:296400 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
