Hi all,

I have the following product table

```
ID Desc
556 Prod A
556 Prod A
556 Prod A
559 Prod C
559 Prod C
559 Prod C
559 Prod C
987 Prod J
987 Prod J
```

I need a counter for each ID, and then concat for a NEW ID column as shown below.

```
ID Desc Line NEW ID
556 Prod A 0 556-0
556 Prod A 1 556-1
556 Prod A 2 556-2
559 Prod C 0 559-0
559 Prod C 1 559-1
559 Prod C 2 559-2
559 Prod C 3 559-3
987 Prod J 0 987-0
987 Prod J 1 987-1
```

so if i were to add another 556 product, the line would look like:

```
556 Prod A 3 556-3
```

Any ideas?