How does the Record Changes property work on a datagrid?

Question:

Can anyone explain why the ‘record changes’ property check box on a datagrid (in my case Opportunity Products) doesnt record any changes made to the values in it.

Also, can anyone recommend an alternative to record any changes made to a product here?

Answer:

Yes, RecordChanges only works on 1:1 tables and products/grids are typically 1:M and, therefore, won’t work.

You’ll have to capture that yourself and write the old values/new values prior after the change is committed.