Needing a static production list
I have been building a database with a lot of products in it. I placed a checkbox on the product description page, simple yes/no, to delimit the records that I need to have put into production. However, I can get them to come up in a simple report, but I cannot figure out how to get that report to stay static, after I reset the checkboxes so that they can be utilized over again at some point in the future for when they are called into production again. Looking for a way to go back and find dated reports that show when these items were sent to production.
Sounds like you need that mouse click to create a new record in a related table linked to the current product record. That record can have a date field to record the date when the product was selected for production. Finding all such records for a given date then finds all products selected for production on that date.