AnsweredAssumed Answered

Defining a container field

Question asked by rowing190 on Aug 3, 2010
Latest reply on Aug 3, 2010 by rowing190


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