I'm trying to use Multi Valued fields for the first time. It appears to work perfectly when adding data but now I'm having trouble when trying to create queries.
I have a table that lists parts & their cost. In another table the user would select the parts required in the multivalued field.
I now want to find out the cost of parts for each record but it appears to only take into account one value from the multivalued list. How can I make it sum up the costs for all parts selected?
I have a table that lists parts & their cost. In another table the user would select the parts required in the multivalued field.
I now want to find out the cost of parts for each record but it appears to only take into account one value from the multivalued list. How can I make it sum up the costs for all parts selected?