Serial numbering

[Peter H]

Hi

I have seen queries along similar lines to this on other posts but they were mainly to do with summary fields rather than creating serial numbers.

What I want to do is to create serial numbers for a field B but reset it to start at 1 when another field A changes.

Field A

A A A A B B B B C C C C C

Field B

a b c d a b c d a b c d e

Serial No

1 2 3 4 1 2 3 4 1 2 3 4 5

Any help will be gratefully received and I hope I've explained my question clearly enough.

Thanks

[Søren Dyhr]

Never the less is it still a display issue accomplished with summary fields, since genuine serial numbers are dedicated to relational linking.

--sd

[Peter H]

Hi Søren

Thanks for the reply.

Using the suammary method the records have to be sorted first, I want these numbers to be permanent so that the records can be sorted in a particular sequence.

In my example Field B is Species and Field A is Genus as in the scientific names of plants and animals. I want the ability to be able to sort them in a taxanomic order. The order they appear in when sorted by genus isn't necessarily going to be the order I need them to be in.

Does that make sense?

Peter

[Søren Dyhr]

Well no because you introduces redundancy deliberatly, you need to break the data into two tables, which then will allow the way way I sliced and diced the data in this thread.

http://www.fmforums.com/forum/showpost.php?post/296180/

--sd