Merging 2 Fields into 1 new one

[rhoneyfi]

I am new with Crystal
I have version 9.0

Is there a way to merge 2 fields into one new one?

Ex: I have two fields called Loan_Number and Deposit_Number. Can I somehow create a new field called AccountNumber that would list both the Loan Numbers and Deposit Numbers? THanks

 

[lbass]

You can concatenate them by creating a formula:

totext({loan.loan_no},0,"&quot+ - + totext({deposit.deposit_no},0,"&quot

But, I read your earlier post about linking, and I'm not sure what this will accomplish for you. I'm guessing that not every customer who has deposited with your bank has a loan also.

If you are still trying to figure out the links, it would be most useful if you explained whether all clients are represented in both tables, all from one table are represented in the other table but not vice versa, or whether each table might have customers not in common with the other table. Probably it would be best to do this in the original post.

Sorry if I'm off track on why you are asking the concatenation question...

-LB