Re: Creating a trigger to search in another table...
Thanks again,
Just two final changes to make me finally shut up.
The variables are not fields but in fact a combitation of fields, which is as follows:
V1 is the value of the field "ValueUoD", which is has been divided by 100.
V2 is the value of the field "ValueLoR", which is has been divided by 100.
The changed variables V1 and V2, are then modified by another field. "UpOrDown" and "LeftOrRight".
UpOrDown = If this field is equal to "D" then V1 is multiplied by -1.
LeftOrRight = If this field is equal to "L" then V2 is multiplied by -1.
Thanks again for any help.
Q. What is big and has no (inter)-face?
A. My database.