i want to create an auto increment Fact id but the problem the fact id should be like this FA001 how to increment it every time when i save a fact
i use this methode
string bill ="fa"
string Num = "001"
for i As integer = 0 to .Numcount -1
Num = val(Num)+1
if (Num.length >= 3 ) then
bill = bill & "Num"
else
Num= "0" & Num
end if
next