3 Replies Latest reply on May 7, 2013 2:24 AM by Mike_Mitchell

    If Statement?

    lee423

      Hi All

       

      I have a list of nominal codes that apply to certain sales as below.

       

      Nominal Codes
      One Way4000
      Return4001
      ALG4002
      CS4004
      CML4006
      INSURANCE4007
      scooters4008

       

      Let take the One Way or Return as an example.

       

      In my dataabse I have a field that is called "service". This field contains a value list as below.

       

      There is another field called "nominal Code" to the right in the booking code section.

       

      In the nominal code field I want to display the nominal code of the option selected in the service field.

       

      Example: Service = Return, nominal code = 4001

       

      There are some other field that will be use to determin the nominal code too like if they have purchased insurance.

       

      Can anyone tell me how this is done please.

       

       

       

      Kind Regards

       

      Lee Brooks