I have the following key
I want a flag depending on the occurrence of the record in the field
if memo 123 repeats again 3 should come and so on. Finally I want to concatenate Memo and Flag.
AutoNumber(RecNo(), Memo) as Flag,
Memo & AutoNumber(RecNo(), Memo) as MemoKey
It is working just fine.
Thanks for the fast reply!
if(Memo=previous(Memo),peek('Flag')+1,1) as Flag
Memo & if(Memo=previous(Memo),peek('Flag')+1,1) as MemoKey
order by Memo;
drop table Data;
This solution is also working.
Thanks for the response!
Retrieving data ...