This is a difficult one to answer without access to your database or a lot more info. on it.

Maybe a database/entity relationship diagram.

Tables can be "related" without "hard coded" Foreign Key Relationships in place at which point it pretty much comes down to a bit of investigation on your part to detect the relationships.