...

View Full Version : foreign keys



irish87
07-27-2006, 08:50 PM
hey,

can you have a foreign key in more than one table.
Ie. could I put a MechanicID (which is the key field of the Mechanictbl) into tblJob and tblOrders??

irish87.

Kid Charming
07-27-2006, 09:08 PM
Sure. You can put foreign keys whereever you'd like. That doesn't mean it's a good idea, though -- that depends on the specifics of your data.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum