Is it possible to write a formula in CR with the below condition: Pls see also the enclosed image also.
If record in column "code" from table, doesn't equal what's in the formula place holder,
show the record from the address column from table
Answer: 203 Albany Hwy
if yes, how do I create the formula which is a place holder.
Why do I need this formula? The information from the formula place holder, is not in the same table or no join table existing, in other words, it is isolated data.
I'm trying to create a placeholder formula or something similar so I can use the information which could have 700 rows (e.g., company, delivery address, state, postcode)
Or, do you have any other suggestion?
Thanks a lot!