Hi, i've been looking through the forum about this and although there are a few suggestions to fix i've not found a complete answer:
I'd like to auto create a membership number starting at 25000 and increasing by 1 each time so i was using a sql query in auto action as follows:
UPDATE'[cb_membership]'='[user_id]'+'25000'
unfortunatly this isnt working - please can you help?
screen shot attached.
Thanks. Ben.