First not empty value between delivery address and document address
If you are unsure about the fact that a a delivery address is always entered, but you always want to display it as the first choice, you can return the first non empty value between the delivery address and the document address.
In the case a delivery address is returned, you will return that address, otherwise the document address will be returned.
*/ The document table must be opened as long as the addresses table.
iif(empty(do_adr2), ad_societe, adr_info(do_adr2, 'ad_societe'))