Problem with serial numbers

[hydrochlorik]

I am having a problem with auto-entering serial numbers into a Packing List file.

What i want to do is for every packing list number have the item number field start generating from "1".

i.e.

Packing List # 398335

have the item numbers start generating from one and continue in increments of one.

then when I create a new packing list number....let's say 398337, I want to have the item number field revert back to generating numbers from one.

I hope that my explanation is clear.

Thanks.

[Fitch]

Make a self-relationship, packing list number::packing list number, let's call it packlist.

Then either by script or auto-enter calc, set the item number to Max(packlist::item number) + 1

[hydrochlorik]

Thanks Tom! That seemed to work.

[Patrick Kuras]

I have a nearly identical requirement, and I tried this technique. I would prefer to create the related records (i.e. those which would contain the "restarting" sequence numbers) by entering data into a portal. It only seems to work when the max(myfield) expression is reevaluated, and this is not predictable. Sometimes it works and sometimes it doesn't. Any thoughts?