Defining a container field
Please bear with me as I do not have much in the way of writing calculations. Here is my query.
Our database has two sets of fields for company addresses - one set of address fields is for the company's physical address; the other set of address fields is for the company's p.o. box. The company may have both a physical address and a p.o. box, only a physical address, or only a p.o. box.
For mailing purposes, I would like to create a third set of address fields. My thoughts are that the third set of address fields would be container fields, but I do not know how to specify the correct calculation.
Here is the logic for which I am trying to write a calculation.
I have three fields - address 1, p.o. address 1, mailing address 1 (this is the container field to be created)
If p.o. address 1 = not blank, then mailing address 1 = p.o. address 1
If p.o. address 1 = blank, then mailing address 1 = address 1
Thanks for anyone who can help with this problem. rowing190