I am a newbie to AirTable. I am trying to design on Asset inventory. I have the parent equipment table, an equipment_model table, a locations table, and an asset table. All categories of the equipment share a common set of attributes (like Make, model, serial number), at the same, some other equipment has completely different sets of attributes (like frequency-range, group/Ch, assigned_frequency, etc…).
I would like to track all the attributes/fields by equipment categories.
What would be the best way to design the inventory?
Please, see screenshots of the equipment and equipment model table