I have a table "Parts" that stores all information on parts in our system in a table like so:
I also have a table Called "NonConfig-PN" that tracks how many parts were bought and in what year here:
here is the relationship between the two tables:
What I'm trying to figure out is if it is possible to get the sum of the "Pseudo" (located in NonConfig-PN table) for each "PartNum" in the Parts table for each given year, for example I'll use TS24
In the NonConfig-PN, I check the "PseudoLines" column for the given "PartNum" and then get a sum of the "Pseudo" for each given year shown here:
So, TS24 in this example would have a sum of 4 in 2021 and a sum of 3 in 2019, 0 all other years.
I would like this done for all parts in the Parts Table. Any help would be appreciated, as I have been stuck on this for a while now.