I have a table which includes claims from the distributor for many part numbers with unique date of shipment.I need to verify whether these claims are correct.
To do the same,I have maintained various updated matrix updated files for each month with different dates,to check the claim
My Issue is,For example if date of shipment is 25/04/18 in claim file,then it should refer the matrix file with the name of 24/04/18 via a linked key.
If it not matches, then it should keep checking the earlier date's of matrix till then the condition is satisfied via key.
After that it should take the value from that file,so that i could verify whether the claim is correct.
Have already linked those two tables,need some help to apply this logic.
Thanks
