Display child post on parent post page

I am working with two custom post types, lets say for example footbal teams and players.

In football team posts I show the team description but using a the post widget I want to show each player they have.

If someone clicks the player shown on the team they will be directed to the player’s post.

Because of the way I work with the database I have custom fields that relate teams and players. Is it possible to use that to display player’s on teams with the post widget?

Thanks!