Hi,
I would like my primary field to be autonumbered, starting with “PW10001”, then +1 value to each new record (so PW0002, PW0003, etc). I think I need a hidden Autonumber column to give me each new sequential number, but I’m stuck on how to string...
Hi all,
[Spoiler: I’m not an IT professional and am pretty new to AT, so thank you in advance for bearing with me :slightly_smiling_face: ]
I have made a ‘contact’ base to hold client addresses, with the following fields (these need to be split ...
Jeremy_Oglesby:
"PW" &
10000 + {Autonumber Field}
Hi Jeremy,
Thank you so much for this. 10k records is fine, thanks. I have copied and pasted exactly, then changed {Autonumber Field} to the col. name, which is “ID”, the column gives “NaN...
Thank you so much Kamille! Works perfectly.
Now I can spend tomorrow figuring how that works :slightly_smiling_face:
Thanks again - very much appreciated.
Mike
