I have a table "order". In that I want to get the weight/roll. Depending of which material I use the weight is different. All the different material I have set up in a another table "product". There is calculationsfeild with the weight of every material I use.
Now I have tried to get the roll weight in a field in "order" table. It depend on roll length ( I have a field for that), roll width ( I have a field for that) and the weight of the material.
How do I get the weight on the field: weight/roll (Have a field for that to) in order?