Formula to bring back all data 1

[lilyr]

I am trying to figure out how to get a custnumber to come back alone if it has shipto assigned to the orginal customer number

I have customer 0004200 and has ship to assigned 001 002 003 004 005.

If I write the formula in crystal as:

if (not isnull({custship.shipto-#})) then {cust.cust-num} + {custship.shipto-#} else {custship.cust-num}


it will only bring back the customer number with the shipto's 0004200001 0004200002 0004200003 etc. it will not bring back the 0004200.

 

[synapsevampire]

Don't use a record selection, just change the join between cust and custship to a left outer.

-k