Replace data from field w/ data from another field

[harry8]

I have a number of fields that relate to the postal address of a company. But sometimes our contact at that company has a different address. So to the right I have identical fields, with slightly different field names. I occasionally use these alternate address fields, making the company address, which would be to the left, irrelevent to that contact. When I export the addresses, I would like the unique contact address, if there is one, to replace that company address in that individual record. How do I do this?

In other words, "If the alternate address fields (on the right) have content, then use that content and not the regular address content (on the left)."

Harry

[jasonwood]

Most of the databases I have seen have Bill to and Ship to addresses.

After the bill to, there is often a button for "Same", which runs a script:

set field, shipAddress, billAddress

set field, shipCity, billCity

set field, shipPostal, billPostal

set field, shipProvince, billProvince

...etc.

[neile]

Define another field as a calculation.

Like your last sentence, the calculation is:

if(name1="",name,name1)

where name is the original field, and name1 the 'identical' field.

Create this calc for each field in the address, then export the new calc fields