Hi all,

I have a project to make in my office. I need to automatically create a
sequential reference number for a set of data. Please see below table.

Cust No. TA No SI date Amount Rate
008-018970 01 0500247 22-Sep-08 12,000,000.00 0.25%
008-018970 01 0500247 22-Sep-08 11,000,000.00 0.25%
050-101393 01 0500324 20-Oct-08 5,000,000.00 0.25%

I have 4 columns (column a-e). What I need to do is to generate a unique
reference code for each item in the row in this format (TA No._MMDDDYY_####)
#-representing the sequential number. Is this doable? thanks!