Help with this script
Dear FMforum users,
The below table is what I created with Filemaker Pro 13. In short, I want the cost to be generated according to the CarType and JobType, each car type can have all of the JobTypes, though the cost differs, for example if you have a sedan and did a SW job, then the cost is 10000, and if you did P then the cost will be 32000, and so on for other types of cars. I tried case script in conjunction with AND, but failed so far to achieve any result. Any help would be appreciated.
Ardalan F. Khalil
P.S. I have a prior knowledge of coding (in Python mainly).