Custom Posts, Meta Boxes, and Relationships

Hi WordPressers

First, apologies if this is the wrong place to post. My issue relates to coding but not plugins.

Second, I’m not a developer so more apologies if this is a simple question.

My question:

I have established several custom post types, lets call them “site”, “operator”, “event”.

I need to establish relationships between them, i.e. every “event” can have a “site” and an “operator” attached. On the “event” frontend, the user could then click through to see more about the “operator” or “site”.

I know there has been a lot of discussion about relationships and the various ways to approximate this functionality using plugins etc.

I am considering setting a meta box on the “event” page with custom select fields for “operator” and “site”. The select fields being populated via a wp_query that returns the relevant titles.

I’ll reiterate, I’m not a developer. I would be very grateful for your thoughts, opinions, or experience of using this approach. What are the pros and cons? Will it work? Are there performance considerations?

It seems quite straight forward, but I worry I may be missing something due to limited knowledge.

Many thanks for helping a beginner learn the ropes.