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?