I have a list of nominal codes that apply to certain sales as below.
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.