AnsweredAssumed Answered

Serial Numbers for Duplicates Fields

Question asked by xfz on Jul 17, 2012
Latest reply on Jul 18, 2012 by philmodjunk

Title

Serial Numbers for Duplicates Fields

Post

Hi All,

I'm pretty new to filemaker. Please excuse my ignorance.

Let's say I have a field like so:

Col1 

asdf

asdf

asdf

qwer

qwer

qwer

qwer

zxcv

zxcv

zxcv

zxcv

 

How can I add a field with serial numbers, with the serials starting over at 1 each time the row above is different:

Col1     Col2

asdf      1

asdf      2

asdf      3

qwer     1

qwer     2

qwer     3

qwer     4

zxcv     1

zxcv     2

zxcv     3

zxcv     4

 

 

Thanks

Outcomes