Data Module

A module in system - to manage data. There are three level of category Main category (level 1) - Contain Category Code, Category Name & Category Desc (if any - not mandatory) sub category (level 2) - is a sub-category for Category 1, contain Category Code, Category Name, & Category Desc (if any - not mandatory) items/details (level 3) - is the detail/data - contain category code, category name, category desc, units and price. Please refer to this mockup [login to view URL] At the moment, no table created for this module. You can propose to design the table. Category Code is not a running number.. User will key-in the code but must be unique so need to include validation for category code. You can introduce a running number as category code ID etc. The module must come with add, edit & delete function. Main category cannot be deleted if still have sub-category under the main category sub-category cannot be deleted if still have items/details under the sub-category