1 Reply Latest reply on Jan 12, 2016 11:22 AM by albi2103

    Multiple shipping costs controlled via 2 fields

    hunterkilla

      I am trying to solve an issue.   I have our booking system setup and we have 3 different shipping costs dependant on a field with postcode dropdowns and a field with 3 options on the delivery. 

       

      So first someone enters the first part of the postcode  say AL1 (field  "Postcode".)    Then on another dropdown field ("deliveryoption") they can choose from 1 of 3 options   Dry Hire, 2 Man cost or 1 Man cost.   then dependent on which options they have chosen it fills in the delivery cost into field "postcode" 

       

      I have attached an excel spreadsheet to show you how it shows you the different costs and we are trying to keep it in this layout in excel so when we update our prices I can do an import into filemaker to overwrite the new costs

       

      Any help would be appreciated.

       

      Steve