Creating A Running Count

:eek: I'm running a Make table query that links two tables in a one to many relationship. What I need to do is add a column that is a running or sequencial counter. The counter is used to preserve the order of the child records thus I don't want it sorted. It would be nice if the counter would reset when the Parent-ID changes. This use to be quite simple in Access 98...so much for better ideas. I have reviewed the other forums, but most deal with totals, I need running count. The others are unclear, so I asking one more time. Thanks

Sample of what I need:
Parent-Id_ Child-Id_ Count
___ 123___ 043____ 1
___ 123___ 121____ 2
___ 123___ 321____ 3
___ 123___ 065____ 4
___ 243___ 032____ 1
___ 243___ 043____ 2
___ 243___ 012____ 3
___ 187___ 321____ 1
___ 187___ 022____ 2