Hi,
I have an invoicing app, and I am trying to create a number of timestamps on the main table that are based on when certain information is getting added, and is for me to track the progress of said job. For example, when the job gets invoiced. Ideally, what I would like to do is to have invoice timestamp monitor the End Time to see when it is not blank, and at that time to create a now(). It does that fine enough, but when I update the jobs form, the DateTime updates as well. Is there any way to get it to update the first time, and then prevent it from changing it every time the form is changed?
I thought about just creating a sub-table that adds a row every time one of the above events occur, but ideally I would like to keep it all on one table. Is this possible?
LinkedIn
Twitter
