Just wondering if anyone can give me some advice on managing records within my solution.
I am creating a property inventory solution where the user creates a property record (Parent), several room records (Child) and multiple inventory item records (Child).
The inventory is created through a number of drop downs and open text fields. The dropdowns are conditional value lists based on numerous dummy records that are created within a script that runs on creating a new inventory.
The solution needs to be as adaptable as possible so I have several buttons that allow the user to add new items etc. to the property as my dummy records won't cover all aspects of every property, they just give the basics.
At the moment all inventory item records are stored in an inventory item table.
I'm trying to figure out the best way of managing these records, ideally I want my dummy record set to be constant and then allow the user to build upon this.