Hey guys,
I have an output that lists a package sku and its components. Each component get its own record. What I need is to autonumber by package sku, like this:
I have seen things about somehow creating a temp table, and using autonumber on that temp table, then appending that data to a master table, and doing that for each package. I was also thinking of making a column of all 1's and just doing a running total (DSum?) but only by each package sku.
We have 12k package sku's, so obviously I can't do this by hand..
Any ideas?