I'm building my first custom webapp, and I'm trying to figure out how to get DSP to automatically store today's date when a given field is changed. I'm pretty sure it will involve a business rule and a stored procedure, but I'm drawing a blank on how to proceed. Any advice and direction would be greatly appreciated!
The field in question is named QueryStatus and is on the tbLog_PrimaryData table. When this is changed, I want it to store the new status and the date on the tbLog_QueryStatusDates table.