I'm just designing a database and have stumbled on a situation where I am torn between approaches and I'd like some experienced input ;)
The situation involves the following tables: Tables: ---------- * User * Show * Musical Number * CreativePerson (composers, lyricists, etc) * Actor What I would like is the ability for a User to create custom lists, i.e. top 10 kind of things. Each list would have a title and description and then any number of ordered list items. A list can only contain a single kind of item (i.e. either shows, musical numbers, creatives or actors). So the thing I'm toying with is how to link each list item to its primary key - either a single list item table or one for each entity or something else....?! How would you approach this? 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:296389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
