Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

v3.0 - updating a field based on another field

Status
Not open for further replies.

TheWkndr

Programmer
May 1, 2002
67
US
My company purchased an add-on package. There is a field in Accounts that uses javascript to hide some sections on the form based on this yes/no field. We actually require three choices, but two of the choices should yield the same form view as the yes option.
Since we're not 100% sure that this field doesn't drive any other events, we would like a way to update this field with a yes or no value based on the choice made in a new field we would create on the form.

Is there a way to update a field easily based on the choices made in another field? js in the onChange event for our new field? (i'm not a js guy, but we have one available).

Thanks.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TheWkndr
Braccae tuae aperiuntur...
 
You could easily put it in a trigger on the DB - BUT OFFICIALLY MS does not like people messing around in the DB

I do it all the time since it is worth any risk of them not supporting us to have the data as we need it.

make sense?
 
Excellent idea that I considered as I've been accused of being trigger happy for years. My real worry was getting the form to change based on that first field being changed by my new field. I couldn't get the onChange event to actually fire, but was looking into it further. The builders of the add-on wired a lot of stuff into the value of that field and unfortunately it's not just a yes/no thing.

Our installation partner actually wrote MS's book on CRM, and their was some examples in there showing the setfocus and fireonchange methods that i was going toexplore further, but they went back to the builder and got them to agree to build an extra field that suits our needs (and will be their problem come upgrade/support time).

Thanks as always all who pondered this.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TheWkndr
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top