I have a "material" database which show the required quantities of each materials in order to build the item. (see below image for example)
Now, I want to create another database with a LineItem portal so when I enter the item name and the qty of the item that I want to make, it will automatically calculate the total of required qty of materials for me.
But for some reason I just don't have the clue how to start. Can anyone pls give an advice or a tip?