I have resolved this using lookup.ini as follows
[AUTOUPDATE]
NewRecord=Uour_ref
[Uour_ref]
Otherwise = &padl(ltrim(str(counter([AcctNo],1,000))), 5, [0])
Overwrite=1
Thanks to all responders.
If I don`t learn to do it here in this Lifetime, Where else would I go and what would I do?
I have been looking around & figured out how to stop any alterations to the field by setting Public read access and master write access so you can disregard that area thanks.
I am no programmer so any help on the other section would still be appreciated.
If I don`t learn to do it here, Who...
I need to automatically populate a field called Uour_ref: with a 5 digit number sequentailly increasing by 1 each time a "New" contact or "New" company & contact is added to goldmine by the users.
EG:
new contact added> our ref 00500
new contact...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.