February 5, 200520 yr 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
February 5, 200520 yr This idea gets discussed periodically. Here's a thread from December: http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB16&Number=136061
Create an account or sign in to comment