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.
Choose the look up code button
Select Association under modules
Choose Relationships under tables
To find a particular table, type in the name in the look for field - top right.