I have a list of buildings and for each building there are certain systems associated with them. The systems are, for instance: heating, cooling, plumbing, elevators. I would like to make a list where I am able to choose multiple buildings and choose specific systems within those buildings. For instance,
<tbody>
</tbody>where under the building cell (A1), I want to be able to select any combination of buildings from a list A to Z, and for each building, an associated set of systems (in the example, I randomly chose A to have 2 systems, C to have 3, and D to have 4), where there are a finite number of systems (say, ten).
From the way I see it, the table will need to be able to automatically adjust itself based on how many buildings are chosen along with the particular systems within that building. Is there a code that will allow me to achieve what I need?
Thanks in advance.
Building | System |
A | Heating |
Cooling | |
C | Heating |
Cooling | |
Plumbing | |
D | Heating |
Cooling | |
Elevators | |
Plumbing |
<tbody>
</tbody>
From the way I see it, the table will need to be able to automatically adjust itself based on how many buildings are chosen along with the particular systems within that building. Is there a code that will allow me to achieve what I need?
Thanks in advance.
Last edited: