I’m new at the bubble, I’m trying to create an online catalog for my factory, I´ve created two lists one called “products” and another called “material”. In my case, a “Product” is formed by various “materials”, that’s because the single price of each material will make the price of the final product. What I want is a way that I can add the materials to the products with the quantity of each and generate the final price. In that way, I’ll be able (i hope so) to consult older products without having to set the materials and calculate again.
Below I’ll upload some images to show how I’m organizing the database