I have this use case - I need to create Configuration (quotation) of electrical equipement for a building. There are rooms in the building, and there is a lot of different equipement in each room (lights, sockets, switches, sensors etc).
I have created Doctype called Configuration, what keeps basic info of the building (name, address, customer etc). Then I have Doctypes Room and Room Item (child table) what represents different Rooms (these rooms are unique for every building). Equipement of the rooms is represented by standard Item.
With all of this I need to create configuration (quotation) of electrical equipement for the building, separated by rooms. Ideal solution is to have one table, where I add a room, and into this record I add all the equipement and so on.
Is there a way how to solve this without nested tables, what I understand as a bad practice as described for example here?