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
Last edited:
