+ Start a Discussion

Update Account Field from Opportunity Table

Now i thought this was easier than it actually is.
I would like to pass the value from an Opportunity field into an Account field.
Of course i cannot use a formula field to do this. I'm wondering if i can update a field with an S-Control that queries the Opportunity table.
I already have the query set up.
var SearchString="Select Type, Membership_Status__c, Membership_End_Date__c from Opportunity where AccountId = '{!Account.Id}' And Membership_Status__c = 'Active'";
Now this will give me a number of records. But i would like to populate a field in the Account table with a value pulled from that query.
Unless there is another way of doing this.
Please help :)



Did you ever figure this out? I'm having a similar problem. Any tips you could give me would be greatly appreciated!