How do you folks handle the access relationships when changing to mySQL? From the manual it looks like the equivalent functionality is covered using foreign key constraints. Is this right?
The foreign key constraints require that both sides of the relationship have the foreign key be the first record of the table. How do you do this when one table has relationships with multiple tables? Only one foreign key can be the first, so it sounds like each table can only have one foreign key constraint. Is this right? Thanks for your help. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
