2 Replies Latest reply on Jun 19, 2012 9:22 AM by philmodjunk

    2 Condition for 1 Value ??

    HandriKent

      Title

      2 Condition for 1 Value ??

      Post

      Hi, I am new in FileMaker. 
      I want to ask how to solve this problem.

      It is about shipping fee.

       

      WeightZone 1Zone 2Zone 3 Zone 4

       300 g90100105120

       400 g100110120130

      500 g110120130140

       

      And I have 2 field for triggering the value

      Weight and Zone

       

      Can you help me?

       

       

      Thanks    

        • 1. Re: 2 Condition for 1 Value ??
          HandriKent

          I am sorry for the table is not appear correctly 

          Weight 300 g

          Zone 1 : 90$

          Zone 2 : 100$

          Zone 3 : 110$

          Zone 4 : 120 $

           

          Weight 400g

          Zone 1 : 100$

          Zone 2 : 110$

          Zone 3 : 120$

          Zone 4 : 130 $

           

          etc


           

          • 2. Re: 2 Condition for 1 Value ??
            philmodjunk

            Won't the weight be a range of values for a given set of zone based fees?

            Such that the first set represents a weght from 300g to 399g and the second is 400g to some larger weight?

            If so, you can set up a table like this:

            w         z       cost

            300      1       90
            300      2      100
            300      3      110
            300      4      120
            400      1      100
            400      2      110
            400      3      120
            400      4      130

            Then you can define a relationship such as:

            YourTable::weight = ShippingCosts::weight AND
            YourTable::Zone   = ShippingCosts::Zone

            Define a "ShippingCost" field in YourTable that uses a looked up value autoenter setting to look up "cost" from this ShippingCosts table. Select the option to copy the "next lower value" if there is no exact match.