Show node in view based on dropdown in seperated content type
I found a solution.

I followed the following steps:


I have created an entity reference (in the content type sport)
I have created a view with relationship to the entity reference
I have created a contextual filter, content Nid with the relationship I created before to the entity reference field.


Everything works now!