The common field between two tables in a one-to-many relationship is the primary key field on the "one" side of the relationship and the _____ on the "many" side of the relationship.

A) sorting field
B) junction field
C) orphan field
D) foreign key field

Foreign Key Field

A column in a database table that creates a link between two tables by referring to the primary key of another table.

Junction Field

A term used in databases referring to a field that connects two tables together in a many-to-many relationship.