3 Replies Latest reply: Mar 10, 2011 8:35 AM by Muncho Ts RSS

    Need some help here.

      Hello all
      Im totally new in QV.

      I have problem with delivery company report.
      I have table like this:

       


      load * inline [
      country, postal1, postal2, zone
      AB, 1000-2000, 1000-3000, 1
      AB, 1000-2000, 3001-5000, 2
      AB, 1000-2000, other, 4
      AB, 2001-4000, , 3
      AB, 4001-5000, , 1
      AC, , 1000-2500, 9
      AC, , 2501-3000, 7
      AC, , other, 2
      AZ, , , 5
      ..................
      ];


      I have postal code from other table like AB, 2540. I need when i select postal code it should show zone number defend on postal1 and postal2. But some countries have postal1 but dont have postal 2, some are don't have postal1 but have postal2, some are dont have bot of them and some are have bot of them.
      please help me. Its making real headache for me now.