>Tables: >---------- >* User > >* Show >* Musical Number >* CreativePerson (composers, lyricists, etc) >* Actor
I'd probably re-think your main tables first. It looks like these should be incorporated into one table because shows, mus numbers, etc all describe one thing. tblEntertainmentItems for example tblEntertainmentItems might contain entItemsID PK entTypeID FK entItemDescr more fields... Then create tblEntTypes and link its PK up with tblEntertainmentItems_X - a linking table tblEntTypes entTypeID PK entTypeName more fields if needed.. tblEntertainmentItems_X entertainmentItems_XID PK entItemsID FK entTypeID Fk This would allow unlimited types of entertainment. Unlimited ANYthing in your schema. You can do whatever you want if items in anything are added. hth, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:296391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
