skyace888 Posted September 19, 2006 Share Posted September 19, 2006 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted September 20, 2006 Share Posted September 20, 2006 There's no reason that your PK can't span multiple columns, if that's what you mean. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.