Relate forms rows rows (pivot table)

Relate forms rows rows (pivot table)

Hi,

I´m looking for your advice about a problem.

I have two forms Team and Player.

In team form I declare the name of the team and in a subform I have some more information which come from a other form (Season & Competicion)

In the player form I declare the name of the player and I need to get in a subform where he has participate each season (the information I have input in the team subform)

Any advice?

Thanks.