Finding Keys in MinistryPlatform
There is much evidence of these Primary and Foreign Key relationships in the Platform, including advanced search, link navigation, and drop-down lists and pick-lists.
Advanced Search
The expandable folders in Advanced Search represent Foreign Keys. When you select these, the Platform adds a JOIN to your query to get fields from related tables. The Advanced Search uses the Table Lookup Convention to represent table joins.
Link Navigation
The small link icons represent Foreign Keys and related tables. Clicking on these will follow the relationships to pages which represent the related tables. Clicking the link next to Contact Status: Active will navigate to the Contact Statuses page, landing on the record "Active".
Drop-Down Lists and Pick-Lists
When editing a record, drop-down lists and pick-lists represent Foreign Keys. When you select an item, you are storing the Primary Key value of a related table in the Foreign Key Column of the page table.