I have a field called [Loan_No] in a table. The [Loan_No]'s format is autonumber.

I have another field called [CP_No].

The [CP_No]'s value should be something like "PMB/Loan_No".

How can I derive the [CP_No] value if i need the [Loan_No] as part of its value??

Please assist.