TGWSE_GY Posted May 28, 2009 Share Posted May 28, 2009 So I am creating a UMS(User Management System) and I have the tables and fields setup. What I am wondering is if as long as my DB is in 4th normal form that if I create a relationship between say the Height column in the Profile_Appearance tbl and the HeightID in the answer_height tbl than if I do a query against the Height column in Profile_Appearance tbl than will it retrieve what is stored in the Height field of the answer_height tbl? If I need to provide more info please let me know. Thanks Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/ Share on other sites More sharing options...
fenway Posted June 2, 2009 Share Posted June 2, 2009 4NF? That's likely going too far.... FKs don't auto-retrieve, they just serve as constraints. Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/#findComment-847741 Share on other sites More sharing options...
TGWSE_GY Posted June 5, 2009 Author Share Posted June 5, 2009 I thought they were a reference to the record on the foreign table. Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/#findComment-849942 Share on other sites More sharing options...
fenway Posted June 7, 2009 Share Posted June 7, 2009 I thought they were a reference to the record on the foreign table. Yes, but that doesn't require a constraint per se. Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/#findComment-851144 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.