View Full Version : foreign keys

07-27-2006, 07:50 PM

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??


Kid Charming
07-27-2006, 08: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