Jump to content

Archived

This topic is now archived and is closed to further replies.

skyace888

Two primary keys with a foreign key?

Recommended Posts

I am trying to implement the model I designed at [url=http://education.alcodesigns.net/projects/coursework/dbmodel9-19-06.gif]http://education.alcodesigns.net/projects/coursework/dbmodel9-19-06.gif[/url] using PHPMyAdmin.  I am having trouble getting the "PLAYERS" table right.  I need to have two primary keys and "TeamNumber" needs to be a foreign key that references TEAM -> Number.  Can this be done?  If so, how?

Thanks,
Al

Share this post


Link to post
Share on other sites
There's no reason that your PK can't span multiple columns, if that's what you mean.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.