I've been searching everywhere to an answer or lead to the problem I am dealing with...
I'm requesting a report to return a dollar amount and any text that might be associated with that amount. If there is no text, assign some generic text to the field.
two tables, TEXT and PACKING
both have a field called co-num which is the record selection criteria
example - co-num=1150100
the PACKING table always contains the co-num but the TEXT table only has the co-num if the user has entered text for that specific amount, otherwise no record exists, but yet I still need to check to see if it there.
I have a formula field with this...
if {text.txt} = "" and {packing.freight} < 0 then
" LESS FREIGHT ALLOWANCE"
else
if {text.txt} = "" and {packing.freight} > 0 then
" PLUS FREIGHT CHARGES"
else
{text.txt}
How do I make a call to check if the record does not exist and still run my code?
IP Logged