AnsweredAssumed Answered

Foreign Key use

Question asked by PaulaS on Sep 23, 2011
Latest reply on Sep 23, 2011 by philmodjunk

Title

Foreign Key use

Post

I've inherited a database with lots of tables. Many of the tables are linked to the main "Projects" table using a relationship such as

 

PROJECTS::__kp_Projectsid ---< RELATEDTABLE::_kf_projectsid

 

However, I'm seeing a whole lot of _kf_ fields in the Projects table, that reference other tables' ID's, even though there aren't relationships using them. Is there a point to having _kf_ fields if they're not being used in a relationship, even if that table is linked using the __kp_projectsid? Is it some sort of standard practice that I don't remember?

Outcomes