itw_peter
Posts: 6
|
Posted: 05/27/2009, 11:03 AM |
|
Hi,
I have 3 fields: account, acct_obj, and acct_sub where the field account is made of acct_obj.acct_sub.
I want user just to enter or update acct_obj and acct_sub, and the form will automatically grab the two values, concatenate them, and update the value of the account field.
Is there a way to do that in codecharge?
Any help will be much appreciated. Thank you in advance.
Regards
Peter
|
|
|
Edd
Posts: 547
|
Posted: 05/27/2009, 4:28 PM |
|
Peter,
CCS has a fantastic facility to custom Insert / Update and Deletes. They don't talk about it much but it is a real winner in my books
Have a look there - you can create your own SQL taking the fields from the forms to do the inserts and updates.
Cheers - Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
Oper
Posts: 1195
|
Posted: 05/28/2009, 7:36 AM |
|
also create account hidden field
During the event on before update or insert
formobj.datasource.account.value=acct_obj & acct_sub.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
itw_peter
Posts: 6
|
Posted: 05/28/2009, 8:58 AM |
|
Edd and Oper,
Great, thank you very much for your help.
I solved my problem.
|
|
|
|