Okay so I have screenprinting business and trying to advance my website!
I have created a data collection for my printing prices without the cost of the garment
# of colors | 12 Shirts | 24 Shirts | etc
One Color | $4.00 | $3.00 | etc
And then I have created another data collection of all the garments I offer at my shop
Shirt Name | Description | Price of Garment
GildanG200 | Some kind of Description | $2.13
now i would like to make a new data collection for the total cost of the garment and the cost for printing by adding 12 shirt QTY @ one color printing + Price of the garment how can I do this?
I want to do this because if down the line i want to update my printing prices this will update all the garments final printing price without having to go in and change every single database collection for each product