AnsweredAssumed Answered

conditional sequence number

Question asked by Kays on Jun 20, 2011
Latest reply on Jun 20, 2011 by Kays

Title

conditional sequence number

Post

hi

i have these 3 tables:

task(idTask)

Stream(idStream, idTask)

Action(idAction, IdStream, SequenceNumber )

What can i do si that the SequenceNumber incremented automaticaly depending on the IdStream.

Example, in the table Action i wanna have:

IdAction          Id Stream            SeqenceNumber

   1                       1                            1

   2                       1                            2

   3                       1                            3

   4                       2                            1

   5                       2                            2

   6                       3                            1

 

thx in advance

K|Z

Outcomes