Jump to content
Sign in to follow this  

Portal Field Update Info

Recommended Posts

I have 3 tables Client, GLCodes and ClientGLCodes. One Client can have many GLCodes and one GLCode can be assigned to many Clients. Hence ClientGLCodes table is created. On the Client Layout, I have a portal for ClientGLCodes where the Rate for the GLCodes can be updated for every client.

So the ClientGLCodes portal on Client Layout has the following fields- Master Rate (Comes from GLCodes table), Client Rate, Rate Modified Date. Only the Client Rate can be modified here. Modified Date is defined as "TimeStamp" field in the table definition. The problem is that whenever a rate is modified, the Modified Date gets changed only after the user clicks out of the portal. I would like the date to change as soon as the rate is modified.

Please help !!!


Share this post

Link to post
Share on other sites

As to my knowledge, the only way to do this is perform a loop that commits record and places cursor back where it was untill user manually commits.

This works only if status area is hidden, because the pause in the loop makes the Continue button appear in it, which is not very friendly.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.