Creating a table in one namespace and inserting into it, but reading and updating it from another namespace
We are developing an interface in Ensemble (v.2018) and would like to have common data visible and updatable from more than one namespace (sort of a lookup, but with more fields).
I can create a table in one namespace and inserting into it, let's say using SQL from the portal. I can also map that table to another namespace. It becomes visible there as a table, but new records inserted in one cannot be seen from the another namespace.
I am reading the documentation, but still no answer. Any help to speed me up?