Question on how to handle one to many mis-match between tables

Hi there,

 

 

 

 

Here is the situation:

 

 

 

 

·         First column X and column Y both have two lines with amounts of 100 and 200

·         Then I modified amountB from 100 to 90 and gave it a version two

·         System sent the modification to TableA/columnX and add a line with -10 (line 3).

 

 

 

 

Table A/Column X	TableA/Amount A	Line A	Table B/Column Y	TableB/Amount B	Version
10	100	1	10	90	2
20	200	2	20	200
10	-10	3
Total	290			290
Table A linked to Table B by column X and Column Y

 

 

 

 

You can see the totals in both tables are the same.  However, if I run following script, for amount A, I got 290 as expected.