Updating too many records
Help please,
I do not understand why this is occurring. I added a pre-update trigger to a datablock to insert updated_by and updated_date to the table when the record is updated. This works fine except when the user execute query to show all records and hits arrows to go through each record, if the user updates record 3, the updated columns are changed on record 1 and 2 as well. Any suggestions on how to update only the current record?
I do not understand why this is occurring. I added a pre-update trigger to a datablock to insert updated_by and updated_date to the table when the record is updated. This works fine except when the user execute query to show all records and hits arrows to go through each record, if the user updates record 3, the updated columns are changed on record 1 and 2 as well. Any suggestions on how to update only the current record?
forms6i
0