AnsweredAssumed Answered

Attempting to add a hyphen to an accession number

Question asked by BrendanHuggins on Mar 1, 2012
Latest reply on Mar 6, 2012 by philmodjunk

Title

Attempting to add a hyphen to an accession number

Post

Hi I am Currently trying to add a hyphen to my accession number script. The current script does not include a hyphen and I have hit a brick wall attempting to figure this out. I hope someone can help.

The script currently reads:

Set Field [new inventory::next accession number; GetasText(GetAsNumber(nex inventory::accesion number)+1)]

I'm just not certain where or what command will achieve my desired result and I have tried a few.

I am using FileMAker Pro 11. 

Thanks for your help.

Outcomes