Forum Discussion
Ireneliu
7 years agoRegular Visitor
Difference between two tables
Hello Everyone, I have a question about the diference between two tables. A Table is for department's actual results. B Table is for department's budget. When the actual results have a value, ...
Ireneliu
7 years agoRegular Visitor
Sorry for late reply.
I tried to change the relationships.
However, when I choose Retirement pension to make sure the difference value is right or not,
finding out the value of Actural results of Salary is included.
Is it because of there is no relationship about AccountName between table A and B?
Ireneliu
7 years agoRegular Visitor
I create a new table for Account Name and make 1:many relationships from Account Name to tables A and B.
Finally,getting the right value.