I receive a number of daily additions to a table (t1), and am trying to assign values from another table (t2) sequentially, and repeat the sequence as many times as necessary to fill the field.
Each record is unique but not sequentially numbered.
The number of values from (t2) can change from day to day
so for records 1,2....10 I have values a,b,c that I would like to make the output:
1 a
2 b
3 c
4 a
5 b
6 c
7 a
8 b
9 c
10 a
I started trying to work it out with autonumbering, the count function, and the mod function, but I can't seem to get it to work at all.