Numbering children

[jasonwood]

Let's say you have a portal, and you "allow creation of related records".

What if you wanted the related records (children), to be numbered sequentially FOR EACH parent as you enter them.... eg: each parent's first child will be "1", the second will be "2" etc. I understand that you can display the line number, but I'd like the number to be stored in a field in the related record.

I know how to auto-enter a serial number... but this is a little different because it is specific to each parent.

--

Jason Wood

HeyWoody.com

[BobWeaver]

Use this auto-enter calculation:

Max(ChildrenByParentID::ChildNo)+1

The Relationship should be a selfjoin in the child file based on the parent ID so that you are only finding the Max of the children of the one applicable parent.

[jasonwood]

SWEEEEET!

Thanks dude!

--

Jason Wood

HeyWoody.com