rows in form get multiplied

Hello, friends

Rows get multiplied in my form and I cant find the reason for that (screenshot attached). In database everything is fine (production order of quantity three shows only three rows, second screenshot). In form code everything is fine, it only consists of two display methods. It would be nice if you could share some knowledge on possible reasons for that.

Best regards,


First of all, you seem to be comparing two different things. I assume the form shows InventTrans, while your SQL query returns InventTransOrigin. What do you get when you join InventTrans?

Also, the form may use a query with a join, which may cause repeated records in the result.