Attempting to add a hyphen to an accession number
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.