hii Nikki Osseforth,
make a helper entity and associate it with your two existing entity Employee and Project with one to one relation
then you can access all attribute of both entities (Employee & Project)
then you can also use refrence selctor and can select Employee name (use data source to Helper Entity)
Have you tried using the selectable objects option in reference set selector ?
Yes, so I want to make it so that the user selects a certain project in a dropdown, which then results in an automatically generated list of Employees that is assigned to this project in this reference set selector, but I should also be able to add more Employees that are not assigned to this project. The difficulty I have here is the I am creating this in a data view of the entity Meeting, while I am trying to use the association Employee_Project.
This is what my (relevant) domain model currently looks like:
I’ve tried doing it using a microflow but because the Data View is of the entity Meeting I can’t get to the Employee_Project association, like this:
I also tried this, but I suspect this returns empty because I think the reference set is loaded while opening the page and the object is empty at that time:
I hope this makes it a little bit clearer what I am trying to achieve, thanks for the help!