I'm trying to create a relationship from thin air, at least that's how it feels.
I have two account roles. Producers and Instructors. I want to be able to reference nodes (events) created by Producers on the related instructors profile page and vice versa. The caveat is that the 'referenced' accounts may not yet exist.
- Producer A creates an event and lists Instructor B (who has an acct and profile) and C (who does not have an account) as the instructors via a multivalue text field (reference field is not possible here).
- Once the node is saved, the system checks for a relationship between the text field data and user profiles. A relationship exists for Instructor B, so the nodes are displayed on her profile. No relationship exists for instructor C yet, so nothing happens.
- instructor C comes a long and makes an account, when the account is saved the system checks for relationship again and finds a relatioship between previous nodes and this new account, the nodes are displayed on the profile.
I am thinking this field could be an email address or something. Is this possible and does anyone have advice on where to get started?