Hi All,
I'd like to add a datestamp and userID when a new CSI is created by our BO staff. I think someone at Wales Millennium Centre did exactly that.
I've considered triggers in many ways - on a local table that is triggered by the CSI creation followed by an update of the Notes field, also setting a scheduled task to look for new CSI's and update the Notes field. But both of these options would only add the datestamp & userID once the CSI had been created. I'd like it to be visible to the user when they open the screen to begin their creation.
Thanks. Debbie