I am working with Drupal 9. I found other questions similar, but I do not understand what they are saying to do, and they are 10+ years old so I do not know if they still apply.

Maybe the best way to describe this is how a SQL JOIN might handle it in a query. I created a simple scenario to explain this. In SQL it might be:

SELECT Children.ParentID, Children.ChildID, Children.Name, Parents.Name FROM Parents RIGHT JOIN Children ON Parents.ParentID = Children.ParentID;

This query would return Parents.Name in the query along with the Children fields, which I could then display. A one-to-many relationship.

In a Drupal example, this would be two content types: Parents and Children. They would have a related field: ParentID (in Parents) and ChildrenParentID (in Children). The ParentID in Parents would be unique in that content type.

I want the Children node to display the parents name (Parents.Name) on a view, how do I go about this? I have been looking at Entity Reference but I am not grasping what I need to do to make this work. It seemed like I was linked but it just gave me a field where I could start typing the parent name and it auto-completed from existing content. (I created some test content types to investigate this issue.)

Part of my problem is that I am new to Drupal and I do not understand all the terminology, which makes it hard to do searches for answers or documentation. Any help or links to articles that explain it would be appreciated.

Kevin