DBGrid is linked to FDTable with CachedUpdates which has two fields as index linked to another table via PART_NO + ITEM_NO pair. This index is also Primary key.
I have a big issue when user is trying to modify ITEM_NO with another value then DBGrid is showing more than one record duplicating other one (not edited one). What is going on? How to avoid "virtual" duplication?
Thanks, Fred

I fixed this issue by replacing TFDTable with TFDQuery but bug in TFDTable functionality still there so it needs to be fixed. How to let FireDAC system developer about this bug?