SEQ Field, when to use it?


#1

Guys, when would you recommend using the SEQ Field Default Value?

For every table I have, I include an ID field, but this is autogenerated and it´s not sequential. SO i´m guessing I need the SEQ value.

Kind Regards!


#2

Are you referring to the subtable $SEQ default value? If so, it’s to generate sequence number from 1 in subtable in each entry. Let’s say you have a sales order sheet with sales items subtable, to generate item # starts from 1 in each sales order, you will need to use $SEQ instead of auto-generate field.