>Definitely read somewhere but can't recall. Is the only to implement sequence ( in Oracle terms ) in VFP to increment integer field in insert trigger ?

There is nothing built into VFP do this, but the concept is you call a function from your default value of the field (which is triggered upon record creation) then lock and increment an integer in a table.

I believe the Tastrade sample on the CD has a good example. If not I could post some code.