Hi - i’m creating an inventory app for construction industry (Electric contractor) where there are several different items and each item have a category and subcategory, so the structure is:
Category > Subcategory > Description
The idea is that this database of items is populated by the construction manager everytime he or she needs a new item (Ex: a diferent type of electrical cable that is not listed on the actual database).
I want this database of items as tidy as posible, so my idea is to autogenerate desciption of new items according to attributes of that specific item. The problem is that every subcategory has a different set of attributes to ask for.
Cable wire --> Cable color, number of conductors, gauge, type of covering…
Led lights —> Watts, Dimentions, color of light…
As each subcategory need an specific set of atributes, I thought to create a table for each Subcetegory and to generate the description as a concatenate of the atributtes prompet in each form. This way the structure of the description for each subcategory would be the same and its easier to control duplicated items.
For more context, there are also tables for Entries, Sales, and a Products table that contains all the items and the actual stock (from the diference of entries and sales).
I am doing well at this point, but i’m having trouble conecting each subcategory tables with the master Produts table. This Products table should be a combination of all other [Description] column of each subcategory table.
I’ts posible that when adding a new item in the Product table the user can select the subcategory of this new item and the app display that specific form so that the description can automatically be generated from the prompted specific atributtes?