AnsweredAssumed Answered

Postfix number added to the value taken from another field

Question asked by macastronomer on Mar 21, 2017
Latest reply on Mar 21, 2017 by philmodjunk

I can't seem to figure this one out...


My records have a field with a text/number in them starting with the year, such as:  2017-Foo01297    They autogenerate and increment by 1.


This is the key field of the main table. In a related file, this unique record from the main table can be activated more than once (in other words, many to one relationship). Therefor I would like a field in this related table that adds run numbers to the end of the main table's identifier, such as: 2017-Foo01297-001, and 2017-Foo01297-002.  The next record in the main database would be: 2017-Foo01298 and therefore the key field field in the related table would be 2017-Foo01298-001 followed by 2017-Foo01298-002. These records will always be created with a script from the main table (through the use of a button and visible in a portal).


I was trying to use the serial number auto-enter along with the field information from the current tables record but it will not let me use the field in that calculation. I'm stumped.


Any help is appreciated. Thanks.