Hi, I am struggling with a database relationship. I have a table "Worklog"which contains historic information about jewellery pieces that include weights and precious metals etc.
I would like to use that information to perform
1, a specific weight conversion based on the metal field stored in worklog table
2, use this new value to quote a new price for the item based on a different metal choice.
(i.e in worklog Ring24 was originally made in 9ct gold but I have a new customer who wants the same ring made in 18ct gold. I have to convert specific weight of 9ct @ 11.4g To 18ct @ 15.7g) and then with this new weight multiply it by the a new updated price per gm for 18ct gold.
Since im a novice, im struggling to get the structure correct and maintain the original. Historic info on my Worklog table.
🤯
Any advice gratefully welcome. 😊