FM Forums don't fail me now!

[Jana]

Hello...I got no response to my previous post, but here it goes again. Someone tell me am I unclear, is it a stupid question, is there no anwswer to my query?

I need to figure out how to define a field that will sequentially number subrecords that are created through a portal of a main related record. For example, I have a table with a field that sequentially numbers records created in a log of images. In another table I have a field that I want to sequetially number the revisions to that original image.

Example: original main records are sequentially number 1, 2, and 3, then I want the subrecords for original main record to also track 1,2,3. I create another field that joins the two numering sequences and display it in my portal rows as the revision number:

First main record with subrecords 1-1, 1-2, 1-3

Second main record with subrecords 2-1, 2-2, 2-3

Does anyone know a way to define my subrecord (portal record) automated number field so that I can get the sequencing I want.

Any help would be great!

Thanks

[Ender]

This idea gets discussed periodically. Here's a thread from December:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB16&Number=136061