Chris,

A foreign key isn't necessarily between 1 field in each table. If you have a composite primary key made up of 4 fields, for example, then a foreign key on this table will have four fields on each side.

Is this what you wanted an explanation of?

Regards,

David.