Dropdown field based on inherited collection

[ksl]

I have a collection called Provider and one called Sites.
Sites inherits values from Provider, since a provider can have many sites.

But the Name (from Provider) should be a dropdown menu, based on the provider name.
And it should not allow me to create new Providers from the Sites page (or any other collections, that it inherits).

Completely new to Nocobase - how can i achieve this?

I would like to my “page” to look like this:

[support]

It looks like you should create two collections, Provider and Sites, and set them as a one-to-many relationship, instead of using inheritance.