How to determine relationships

SAMS C/S is a relational database which allows each table to "speak" to others.  To do so, they must be linked by a  common field - typically an ID number.