Table Primary Key Foreign Key OfficeTitles nTitle_id Offices nOffice_id nTitle_idIn this example, for Offices, nOffice_id would be a Primary or candidate key and nTitle_id would be regular. Your relationship is from OfficeTitel.nTitle_id index to the Offices.nTitle_id index and is one to many.