Thanks for reading. I have two tables in my database: 1 is called Amounts, with AmountID and AmountWorth, and 2 is called MultipleAmounts, with MultipleAmountID, AmountID, Number. Each row in Amounts stores a number (the "worth"), for example:
AmountID: 1 (primary key, auto increment)
AmountWorth: 500 (actual amount)
Each row in MultipleAmounts tells how many multiple amounts there are in the Amounts table, for example:
MultipleAmountID: 1 (primary key, auto increment)
AmountID: 1 (which AmountID it belongs to in table Amounts)
Number: 5 (the number of the times the amount appears, AmountWorth multiplied by this number is the actual worth of that amount)
I hope I am clear. Can you please help advise or provide a quick script of how I can get the total amount of everything combined correctly? Thank you so much. It's late and my mind is mush, but I really want to get this configured. Any assistance is appreciated.