AutoUpdate field with result from Stored Procedure

[RSfromCO]

We have a stored procedure in MS-SQL database that maintains the next customer account number that should be used. When we update a contact record in GoldMine and change the contact type (Contact1->Key2) to a "Customer", we would like the Account Number (Contact1->Key5) field to AutoUpdate with the next customer account number from the stored procedure.

We use the Lookup.INI file to AutoUpdate fields using dBase expressions, but I don't know if I can call a stored procedure and place its results into the field.

Any suggestions ?

 

[ddeegan]

I use Triggers, they work fine.

In Enterprise Manager, RC table, select All tasks, then "manage triggers".

Good luck
Dave

 

[RSfromCO]

OK, I setup a trigger in the database so that if the Contact1->Key2 field changes to "Customer" then the Contact1->Key5 field is automatically populated with the next Customer ID from the stored procedure. GREAT !!!

Now I need that value to be displayed on the GoldMine screen where the Key5 field is being displayed. If I move to the next contact record and back again I see the new value, but I would like it to be AutoMajically displayed while I am still sitting on the contact record that I just changed Key2 to "Customer".

Any more suggestions ?