Hello Everyone!
I will try to explain my problem as clearly as possible:
I have a table for production tasks, that stores information about:
Prod_Task_Number, Start_Date, End_Date, Product and others.
I also have a table with info from some other documents with information about:
Product, Date_Stored and others.
I want to have is that those two tables are connected by the Product, which is easy, but also by the dates.
So when filtering Prod_Task_Number, I want the second table to show values only for Product associated with that Prod_Task_Number and Date_Stored for all dates between Start_Date and End_Date.
Is that doable? And was I clear in my question?
Any help would be greatly appreciated 🙂