AnsweredAssumed Answered

serial number

Question asked by KatG on Apr 22, 2012
Latest reply on Apr 24, 2012 by KatG


serial number



I have a basic DB with a one to many relationship. I have created a layout using the parent table as the source table and then I have added portals. Both tables have the ID serial number key.  The portal records are grouped by date and sorted in descending order by the table_ID.  I would like to add a field with an automatic number that would reflect 1, 2, 3, 4, etc. for that date and then when I add records under a different date, it would start again as 1, 2, 3. etc.  I am using a checkbox for this now but I would like to be able to save the step if possible. Thanks I really appreciate all of the help I have received on this forum!  Oh and I am using the trial verion of FP 12, and loving it .... so far :)