Help me please ...
I have the following table and need to create a new column with a numeric sequence according to the amount of photos of each product.
I wish the results were as shown below:
if( peek(idProduct) = idProduct, peek(Sequence)+1, 1) as Sequence
I think much easier is
autonumber(Recno(), idNumber) as Sequence
Retrieving data ...