TRIGGER problem - Help please!
I would like to use a trigger to make 2 changes, but my code only seems to make one change and I can't figure out why...can anyone help please? Am I trying to do something that can't be done?
Below is a snippet of my code, it changes the insurance value amount in the desired field, but not the courier charge. I had not originally put the brackets in, ninox does this automatically.
I have tried putting the courier charge section in brackets too, ninox just removes them again.
if 'Courier Type' = 1 then
'Courier Charge' := 29.99 and ('Insurance Value' := 1)
if 'Courier Type' = 2 then
'Courier Charge' := 34.99 and ('Insurance Value' := 2)
Thanks in advance! Anna
Thanks Fabio, I'll try that out.
Not sure John, and apologies if people had replied. I haven't received any notifications from Ninox about my other post, so assumed it had just gotten lost in the forum. Is there a place within Ninox here where you can find your previous posts and questions easily do you know?
it's not easy to track your posts but what you can do is keep doing what you are doing
ie put your name on the vbottom of th epost Anna - that you can search for that
Better still just put anna on any replies you make and put something to help you get back to your own posts ie Anna (NP) ....NP = New Post