ok... i have been trying to just make lists like this for the last 3 weeks. guess your right will create a new table and do it the right way. thanks! -paul
On Tue, May 27, 2008 at 10:20 AM, Dominic Watson < [EMAIL PROTECTED]> wrote: > >Events_Placement_ID (PK - autoincrementing integer) > >Events_ID (FK) > >Placement_ID (FK) - or a better name, related to what those ids are linked > to > > I should add that you also need a unique constraint on the two foreign > keys and that the primary key is optional and only necessary should > you need to relate to a single event placement in another table. > > Dominic > > -- > Blog it up: http://fusion.dominicwatson.co.uk > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
