This has to be controlled by the relationship itself.
What are your tables and how have you currently related them?
A simple way to do this is to use this type of expression to list each relationship:
Table1::keyfield = Table2::keyfield
Tables weren't linking because one of the keys had no data in it... Working now.
PS: i <3 PhilModJunk