Hi Shikha,
I think the best way to achieve this is to have the objects that are in the external entity, copied to a local non-persistent entity and map with the reference selector to this non-persistent entity.
like: retrieve from external entity, and commit that list in you local non-persistent entity.
This way you keep the data persistent in the external database, but you enable your user to select them locally.
I hope this wil work for you. Good luck,
Jan
This should work as you modelled it. Unfortunately the error message is not readable, could you past the entire error in here?
For reference, here’s a similar example: