I have a for having many fields. one field is bill_no and another is BillID.


Bill no is same for some records but BillID is a sequential number which is unique for every record. What I need is that when bill_no change the BillId set to zero and start again from 1. For Example

Bill No Bill Date Bill ID Emp No Amount

ba/02/01 ...... 1 23445 45
ba/02/01 ...... 2 23568 50
ba/02/01 ...... 3 25896 60
ba/02/01 ...... 4 25635 105
......

ba/02/01 ...... 1 56324 52

Or it may possible that rather BillID we use a field as autonumber and set it values as bill_no change.


Thanks.