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 Link to comment https://forums.phpfreaks.com/topic/21315-two-primary-keys-with-a-foreign-key/ 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. Link to comment https://forums.phpfreaks.com/topic/21315-two-primary-keys-with-a-foreign-key/#findComment-95186 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.