Hello Beth,
I think that the first question to ask yourself is whether those red tables are indeed master data which goal is to pertain to the MDM? And as such, shall they be populated/managed through it?
If yes, then they can be created as any other entity.
If not, then how to proceed will heavily depend on your context.
This could indeed be achieved through DB views, or you could also use our dashboard capabilities.
If required, I can convert this topic into a ticket to put you in contact with our Professional Services team who will be much better equipped to dig in your context to help you determine the best approach to answer your requirement.
Please let me know if that would interest you.
Have a good day
Alexia
Yes that interests me. Please convert it into a ticket to help dig into the context.
Hello Beth,
Duly noted, I've created a ticket for you based on our exchange.
Talk to you there.
Have a good day.
Alexia
Beth Orta
My question is a two fold so bear with me.
We have reference entities or lookup entities that our users will modify what the options are for that topic. Ie Multiple Agents entity rows Yes, No, Unknown.
They have requested to be able to modify it at a lookup entity level and a group level. Meaning each lookup has another entity that it has a relationship to the lookup table and to our customers table. The idea is that they want to answer questions (aka lookup) based on the specific customer and question if there is only one change.
However they would like to also be able to edit in the application all the lookups per one customer in one view. The model is as follows:
We are able to get the green and yellow to work successfully but we are struggling with the best way to implement the red.
Can database views be added to an application? Or would it be better to have the total view in a entity and build an app from there? If the second option how do I built the collection and form so that they can see various pieces of each green table and the pinkish purple table? Basically they need to select the customer and select the option.