foreign keys

[irish87]

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]

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.