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
NOTE: everything needs to be discussed and negotiated first. the
default terms are placed to ensure such discussion takes place before
job is awarded. first milestone becomes payable immediately after work is started.