Hey everyone, new here! I am working on a project where I have the tables customer, CodeCost, and CategoryCost. Each record of CodeCost contains a code (‘1001’) and a cost. These costs are manually input so no problem there. The category costs come from a group of codes that match the first two numbers of the category. i.e. category 10 contains 1001, 1002, 1003. Customer is self explanatory.
I was trying to set up a calculation (not sure if I should set the field to a calculation or just to a number and then calculate through the options page, should I use one over the other?) the calculation would check each record of CodeCost and determine which customer it belonged to, determine the category from the code, and then add it to the category cost.