Please take a a schema:
(http://s20.postimg.org/bbtxq73u5/Snap6.jpg)
I want to create a view in presentation layer and i cant figure out how to do it.
I need to have ONE line per F41021, and i need to get two sums from F4102 and F4311...
the keys that are in the relationships are the green fileds. I need the sum of the yellows.
If i just make a new query subject and put the fields i need inside i get duplicate lines.
I tried many things with determinants but he doesn't want to to make a sum from these tables on the final query subject.
I would appreciate any help in understanding how to approach this.
I tried to approach it in this way and it seems it works..Is this the correct way?
(http://s20.postimg.org/5dkptpa99/Snap7.jpg)
(http://s20.postimg.org/bsjqqdgz1/Snap8.jpg)
Were you intending to attach images or something to your messages? I do not see them, but then it is Monday morning for me and perhaps the caffeine has not quite reached my brain. :-\
But ican see them....
1 in the first post and 2 at the second...
http://s20.postimg.org/bbtxq73u5/Snap6.jpg
http://s20.postimg.org/5dkptpa99/Snap7.jpg
http://s20.postimg.org/bsjqqdgz1/Snap8.jpg
Oh I see... sorry, my employer's web filter is blocking access to the site with the images. Why - who knows? Ugh.
I will try to look later from home or somewhere I am not filtered.