Repeating Serial Calculation

[capisco]

Goal: In an Event Table the Repeating Field "Company Serial" displays the Serial of each Company via a Relationship matching the Repeating Field "Company Name".

So far, no dice. I've tried defining "Company Serial" as:

Number Field (Auto-Enter Calc) ... but all serials mirror the 1st entry

Calc Field ... but only the first entry gets a serial

Calc Field (with Extend) ... but all repetitions mirror the 1st entry

Please see attached "Serial Errors" (the three repetitions should read 1004, 1061, blank). Any thoughts welcome, and my thanks in advance!

[bruceR]

If you have to ask questions about repeating fields you shouldn't be using them. Use a related table.

[Søren Dyhr]

If you have to ask questions about repeating fields you shouldn't be using them

This is the most succinct way of expressing it I ever have seen ...

--sd

[capisco]

My thanks to both of you. Succinct indeed, my girlfriend winced.

But it works, works great*, and I will use it as a mantra going forward.

* Unless, by chance, it's causing my now constant crash of FM; if such help-mates care to look at my latest post I'd be even more appreciative. Topic #213299

[Søren Dyhr]

Anything requiring a grid from where you apparently are supposed to eyeball events or similar, should not be done via repeating field - but instead use a relational structure:

http://fmforums.com/forum/showtopic.php?tid/176396/post/204083/#204083

--sd