Making Consecutive ID Number

[hydromike]

I have a four Letter Code that I want to prepend to an ID Field, ECHR0001, or AGAV0001.  I am a total newbie i can get the letter to generate but i can no t get the auto increment to work with this.

[comment]

This comes up from time to time, and I believe the best advice is not to do it. See, for example:

https://fmforums.com/topic/97905-multi-part-composite-serial-number-for-items/?do=findComment&comment=445025&_rid=72594

https://fmforums.com/topic/108054-a-midsummer-nights-filemaker-challenge/?do=findComment&comment=486371&_rid=72594