Jump to content
Sign in to follow this  
edmonton

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 !!!

Thanx

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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