x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 75 subscribers
  • Views 668 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Daniel.Jeffreys

Custom Entity Progress Table - No insert for edited record

Posted By

Hi,

I have created a progress table for a custom entity I created. When I add a new record to the custom entity it adds the details to the progress table but when I edit the record it does not add a new record to the progress table. I have no way of tracking changes in my custom entity. I have looked around the net and read articles that got me to this stage but can not figure out a solution. Any help would be grateful.

Thanks,

Daniel

  • 0

    Hi Daniel,

    I have not tested this myself yet, but have you linked the progress table to the main entity? Check custom_tables.
    The other thing I normally do is just add some code to create a progressnote in the appropriate progress table when the save takes place on the main record. You can do this in the ASP page itself, or even cheat a bit and use scripting in the table scripts side.

  • 0 in reply to Conrad Roux

    Oh yes, you can also do a SQL trigger to create it for you if you are more comfortable with SQL. Triggers are a fast and easy way to do that as well. The only trick will be getting the changed records to display, but that should not be a problem if you google a bit.

*Community Hub is the new name for Sage City