2 Replies Latest reply on Mar 13, 2015 1:19 AM by ArdalanKhalil

    Help with this script

    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