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

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

--sd

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

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