Use loop for iterating Row no

[siddharthsoam]

Hi 

I have one table1 (Prod_name) having fields

Prod Code

Prod Subcategory

Brand

Prod Name

& the other table2 Prod_Price having fields

Prod Code

Prod Subcategory

Brand

Price

Here key between the two table is of Prod_Code,Prod_Category & Brand

I want to make a field called Rowno which gets iterated for the same key and the counters starts once again when encountering another key. Desired output is as follows

Prod Code	Prod Subcategory	Brand	Price	Row No
PA1	PB1	L	12	1
PA1	PB1	L	23	2
PA2	PB2	V	13	1
PA2	PB2	V	13	2
PA2	PB2	V	13	3
PA3	PB3	X	34	1
PA4	PB4	O	32	1
PA5	PB5	H	17	1

[agni_gold]

Try something like ,

AutoNumberHash256([Prod Code]&[Prod Subcategory]&Brand)