ID text fields

[John Grandy]

Couple questions regarding ID text fields :

I would like my ID field to operate similarly to a SQL Server Identity(1,1)
column. So, each new record added is given a value equal to the most
previously added record ID + 1.

Is it possible to do this ?


Also : how to retroactively populate an ID field for pre-existing rows in a
view ?

 

[Fabrice BARBIN [Groove MVP]]

You have to keep in mind that Groove can be used offline.
Using your approach, it means that several users - for example being offline
at the same time - would be able to create entries having the same ID...
It is why in groove IDs are not only incremental...

HTH

--
---------------------------------------------------------------
Fabrice BARBIN [Groove MVP - Groove MCTS]
http://blog.fbarbin.com

Hommes & Process (http://www.hommesetprocess.com/en)
GrooveIT! (http://www.grooveit.biz)