AnsweredAssumed Answered

Help with this script

Question asked by ArdalanKhalil on Feb 3, 2015
Latest reply on Mar 13, 2015 by ArdalanKhalil

Title

Help with this script

Post

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. 

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
CarTypeJobTypeCost
SedanSW 
SUVP 
PickupIC 
Mid-size truckEC 
Full-size truckIB 

 

Best regards, 

Ardalan F. Khalil 

 

P.S. I have a prior knowledge of coding (in Python mainly). 

Capture.PNG

Outcomes