How to show specific field value based on another field value

Hi,

I have three custom post types one is football_team and others are football_players and football_fixture.
I have a metabox under football_team CPT with ID recent_players, which contains recent players list.

I have four metaboxs under football_fixture CPT which contain home team name(ID:home_team),away team name (ID:away_team),home players(ID:home_player),away players(ID:away_player).
Now my query is: If I select a specific team ,which is published under football_team CPT,under home_team then it will automatically load the recent players from recent_players metabox.

Is it possible?
If so then I will give you the codes.
Thanks in advance.