You need a Join-Table, not a Self-Join. Its an extra table that goes between two instances of the People table tying them together.
People_mentors <-> Join Table (JT) <-> People
In both cases the join field is the People primary key but they connect to different fields in the Join Table
People_mentors::primary_key <-> JT::mentor_key
People::primary_key <-> JT::people_key
Set the Relationship People <-> JT to allow creation of related records in the JT.
Create a Value list using the People Table and its PH, showing only the second field, people full name. This assumes the People full name field is unique. If it isn’t then show both fields and sort by the full name.
On a layout associated with the People TO (Table Occurrence) create a portal and inside it put the field JT::mentor_key and attach the above value list. Now on the first portal row select anyone from the value list and a new record will be created in the JT with the mentor as the related person.
Thank you! I actually was moving in this direction, but in a more
Are you open to additional questions as I work through this? Hopefully, I
won't have any, but...
It works! Again, thank you for taking the time to help.