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.
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.