AnsweredAssumed Answered

If Statement?

Question asked by lee423 on May 6, 2013
Latest reply on May 7, 2013 by Mike_Mitchell

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

Outcomes