.. my actual situation is there will be
more quotations on a single day per customer

Can you show how then should the quote refs be generated?
Take the sample data below for 2 customers, indicate in your reply:

Date_____ Cust QuoteR
1-Oct-08 4628A
1-Oct-08 4670B
1-Oct-08 4628A
15-Oct-08 4628A
15-Oct-08 4670B
15-Oct-08 4670B
16-Oct-08 4628A

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---