Lets say I want to store transaction details of an "Inventory" that might be a child of a multiple types of "Planting", or of "Receivings", and become the parent of more "Plantings", "Packaging Runs", or "Wastes", for example. Inventories must also be able to parent other inventories so that lots can be split and combined.

But I don't know in advance if my Inventory is going to becomes seed, or be sold, so I can't have a different Inventory forms for each type, such as "Inventory_from_Receivings_Designanted_for_Sale", and "Inventory_from_Harvest_designated_for_Seed", etc. I realize that by requiring this flexibility will take a toll on query speed, but I'm not sure whether this is even possible within Zoho Creator. Any advice for the best way to do this?