AnsweredAssumed Answered

Managing Records

Question asked by MatthewMackay on Apr 28, 2011
Latest reply on Apr 29, 2011 by philmodjunk


Managing Records


Morning all,

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.