Worked like a charm thanks for the help Ross!!!!
I was looking for the right way to refresh a field on a save or update event.
Here is my scenario. I have a trigger that runs when a new Part is added to the Job. The trigger updates a user defined field in the Jobmtl table based on several parameters. Basically it grabs the vendor part number from the vendpart table.
This works great. I then display the field in the material Tab. However, in order to get the Vendor Part to display in the field immediately after the trigger runs I need to hit the refresh button.
Currently I added a button that uses the otrans.refresh() code to update the field.
What i was trying to achieve was an automatic update when the record is saved so the user doesn't have to hit the Refresh button.
In summary:
After a new material is added to the job I want to refresh the Jobmtl Sheet of the current job.
Any help on this would be appreciated.
Thanks ahead of time
Here is my scenario. I have a trigger that runs when a new Part is added to the Job. The trigger updates a user defined field in the Jobmtl table based on several parameters. Basically it grabs the vendor part number from the vendpart table.
This works great. I then display the field in the material Tab. However, in order to get the Vendor Part to display in the field immediately after the trigger runs I need to hit the refresh button.
Currently I added a button that uses the otrans.refresh() code to update the field.
What i was trying to achieve was an automatic update when the record is saved so the user doesn't have to hit the Refresh button.
In summary:
After a new material is added to the job I want to refresh the Jobmtl Sheet of the current job.
Any help on this would be appreciated.
Thanks ahead of time
Add an AfterAdapterEvent type with the Form Event Wizard. Make it trigger
on "Update" and add otrans.refresh() to the case code.
Ross
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joshua
Sent: Tuesday, June 01, 2010 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Refreshing a Field On an update Event
I was looking for the right way to refresh a field on a save or update
event.
Here is my scenario. I have a trigger that runs when a new Part is added to
the Job. The trigger updates a user defined field in the Jobmtl table based
on several parameters. Basically it grabs the vendor part number from the
vendpart table.
This works great. I then display the field in the material Tab. However,
in order to get the Vendor Part to display in the field immediately after
the trigger runs I need to hit the refresh button.
Currently I added a button that uses the otrans.refresh() code to update the
field.
What i was trying to achieve was an automatic update when the record is
saved so the user doesn't have to hit the Refresh button.
In summary:
After a new material is added to the job I want to refresh the Jobmtl Sheet
of the current job.
Any help on this would be appreciated.
Thanks ahead of time
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
on "Update" and add otrans.refresh() to the case code.
Ross
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Joshua
Sent: Tuesday, June 01, 2010 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Refreshing a Field On an update Event
I was looking for the right way to refresh a field on a save or update
event.
Here is my scenario. I have a trigger that runs when a new Part is added to
the Job. The trigger updates a user defined field in the Jobmtl table based
on several parameters. Basically it grabs the vendor part number from the
vendpart table.
This works great. I then display the field in the material Tab. However,
in order to get the Vendor Part to display in the field immediately after
the trigger runs I need to hit the refresh button.
Currently I added a button that uses the otrans.refresh() code to update the
field.
What i was trying to achieve was an automatic update when the record is
saved so the user doesn't have to hit the Refresh button.
In summary:
After a new material is added to the job I want to refresh the Jobmtl Sheet
of the current job.
Any help on this would be appreciated.
Thanks ahead of time
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links