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.