running count of self-related records in a table?

[seanc]

Hi Everyone,

I'm sure I've done this once before, but I can't for the life of me work out how, so any ideas would be much appreciated.

I have a table with 10 records in it and a self relationship that contains 4 of these records. How can I have a field that shows the sequence number of those related records (ie. 1-4) in alphabetical order (they were entered in random order)?

I can do this easily in a portal, but that won't help me in this case.

Also, I'd like to avoid using a script.

I can set the first related record to 1 easily enough, but thats as far as I can get.

Thanks again,

Sean.

[-Queue-]

Create a value list using the self-relationship TO's field that you want to alphabetize, 'starting from' the original table. Then make your sequence number field equal to

Let( V = ValueListItems( Get(FileName); "yourValueList" );

ValueCount(Left( V; Position(

[seanc]

Hi -Queue-,

Can't think you enough for that Works a treat.

Glad I asked, I don't think I would have worked that out.

Having a bit of trouble coming to grips with FP7 and relationships, especially when it comes to value lists...

Thanks again,

Sean.