I'm trying to generate a relationship in a BO from a PICK FROM list.
I have a BO called WORK with a recursive relationship CONTAINS.
I have another BO called PARTICIPANT which has an OB relationship to WORK.
I am trying to PICK FROM a list of PARTICIPANT (from a query - WorkPartPickCompilation) and then INSERT the PARTICIPANT.OB_WORK into WORK.PM_CONTAINS but I am getting an Internal Error that isn't more fully explained in the console.
You mention that Work has a recursive relationship to it self (right?)
And Work has multiple children called Participant
If you are trying to insert Work into Work, why is there a Pick pointing to Participant.
So please explain, are you trying to insert recursive Works into Works, or are you trying to assign 1 or multiple participants to a work record.
The reason that I need to use the Participant as an intermediary is that there is not enough uniquely identifying information (that is meaningful to the User) in the Work for the User to correctly identify the Work.
Multiple but different Works may have the same title. It is not until you attach an Author (Participant) that the Work becomes unique. Works may have multiple participants (Authors etc), so I can't directly attach the Author as an attribute to the Work.
Hence I am trying to identify via the Participant a number of Works by Author to attach to another Work (Consider a compilation of short stories)