Over-ride a blank field with a default field.
So I'm creating delivery notes. I have a client table with their default address. I also have a delivery address on a job ticket table.
When printing a delivery note, I would like to first use the delivery address on the job ticket table. But if this field is blank, then to revert to the default address on the client table.
Could some one give me a nudge in the general direction of how to learn how to do this?
Tried searching the training resources and the forum but I'm struggling to come up with anything.
Thanks a million as aways.