On the main form I have those mentioned datasources.
I needed new form that I will use to merge data from other records.
Example:
1. record: Record 1 (parent) has Child record 1 quantity 10.
I want to merge more records (quantity from child DS).
So I select other record (parent also, for example Record 2) that I want to use child 2 from that has quantity 5.
So the result needs to be
Record 1, CHild 1 qty 10, Child 2 qty 5
Record 2, Child 2 qty 0 (decreased since it is now part of Record 1)
And when I reopen the new form it should show only the child records that are merged, so no the ones that alreadi existed.