hello.

is there any way to do this?

annually members will submit an image and or a reference which will change.( it is the bank reference for the payment of fees )

we need to be able to display the current field on the user profile and somehow collect all the previous years into another filed to produce a list.

ie

this year reference : REF7165278265

last year reference : REF0702753037
year before reference : REF 087301723

so fields stored would be

current : REF7165278265

history :
REF7165278265
REF0702753037
REF 087301723

does this make sense?

the same would go for the image url's

thanks

thanks for the reply

so,is there any way to "collect" the past entries ( references /image url's) into another field for archiving?

ie , when the current field is updated, the immediate past field is added to the year before, and the year before that etc, ie all the previous references / url's are stored to review at some time in the future.

i found this:
geekswithblogs.net/VBTips/archive/2008/04/25/how-to-append-to-a-sql-text-data-type-feild-again.aspx

Update [tableName] Set [myField] = [myField] + 'whatever' Where [id] = 1

would this work in a way with cb queries action? or auto actions?

thanks

this is what i have tried thus far. any suggestions?

if the [cb_bankrefhistory] is empty, put [cb_bankref] in it

thanks