I am assuming that you mean that a user can create a top10 list or any or all of the other tables.
I would create a join table. Ex. Top_shows That table would have at least 2 colums (3 if you want to be able to have the user order them) Userid Showid (priority) This way you can store the list and keep from having redundant data between the several tables Hope this helps, William Seiter (mobile) Have you ever read a book that changed your life? go to: http://www.winninginthemargins.com and use passcod: GoldenGrove -----Original Message----- From: "Dominic Watson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: 1/10/2008 5:28 PM Subject: OT: DB Design question 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:296399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
