Cross-Datastore References

Good morning.
I´m facing complications trying to define an associated attribute with a secondary database column.
Scenario is: Entity Employee from DATABASE A needs an attribute “Organization” which has to be associated with entity Organization from DATABASE B.
I read all topics in the forum and also documentation, Additional datastore is correctly configured, also DATABASE B storeConfiguration.java is created succesfully, but still can´t manage to do it, when I try to create attribute with association type there is no option to select from another database.
Maybe I missunderstand what is this for… but to be clear I want to see for every employee what organization they are working in.

Thank you in advance.

Hi,

I’ve checked your case and it seems to work fine both in Studio and in the runtime.

See my application: cross-datastore.zip (124.1 KB)

Two datastores are configured. Employee from the main datastorehas a reference to the Organization from the secondary datastore.

Please provide more details of what are you doing, what steps are you executing and what goes wrong on each step. Also what Jmix version and Jmix Studio version do you use?