I'm getting into one of those areas that I barley understand, I know this is a big concept so I am hoping someone can point me to an example in NorthWind that might help, or tell me what this concept is so I can search and read up on it.
I am trying to Capture a set of data at a moment in time, I guess similar to a receipt for a transaction, where the price of an item on the receipt is permanent even thought the price of an item may change.
what i need to do is track deadlines and fines.
for example in May 2020
Who Item A Item B Fine Person 1 No No $200 Person 2 Yes No $100 Person 3 Yes Yes $0
now this is great except at some point person one is going to turn in Item A and Item B and those columns will say yes and yes.
But I am going to want to look back and see in May they had not turned in their items