I know that the relational data model doesn’t allow us to do something like that but I have to find a way out.
Let’s say I try to create a spare part shop, and can sell parts themselves and assembled ones. I want to create an entity SparePart (let’s say ‘engine’) that contains a list of other SparePart’s. No problem with data model, I create an entity SparePartsList and everything goes fine. The problem is in creating views and screens for editors. Obviously.
I’m stuck on creating a list. I don’t want to create a separate ListEditor screen, I want to be able to see the list of inner parts (if list is not null) and to add more parts to the list right from the view SparePartEditor.
I guess my question is so complex that it needed a full guide, that’s why I’m sorry for asking it in that way.