Hi everyone, firstly thankyou to everyone who has helped me so far i'd be lost without this forum!
I have recently created a database that calculates the amount of manure our farm is allowed to spread due to regulations. The limits are based on a number of things but one is the crop which the field currently has in. At present I have a form which navigates the recordset of our fields (tbl_destination) and the current crop is stored in there, and modified every year. But a long story short we now want it to be able to look back 2 or 3 years to see what crop it has had in, and be able to generate all reports as though they had been printed at the respective time as a problem is that at the moment, i can jump back a few years to pull information back, but they do the calculations presuming that they had the current crop at the time if that makes sense?
I will attach a screenshot of my table relationships if it will help but sadly the database is about 4mb compacted so too large to upload - the cluster of tables related to my issue are the ones at the bottom of the screen around tbl_destination
What do you guys suggest is the best way to adapt my database to allow reports to display correctly? New crops get assigned to the database roughly 1st July every year, so a temporary fix is to print all reports before new crops are assigned and keep the records on paper, but that defeats the point slightly of using this system...
thanks in advance!