AnsweredAssumed Answered

Sequential numbering per ID

Question asked by MikeF on Nov 7, 2011
Latest reply on Apr 7, 2013 by pokerbear


Sequential numbering per ID



Need to create sequential numbering per foreign key field.

Example using persons attending meetings ..

If field MeetingID was 101, and three people attended, in the SeqPersons field they would be numbers 1 thru 3 respectively.

If field MeetingID  was 108, and five persons attended, the SeqPersons field would automatically number them 1 thru 5 respectively.

Is there an easy way to accomplish this?


-          Mike