I'm creating a database for a business. It has a table of Sites and another table containing a column with Site, another column containing Sequence, with each site having 5 or so rows, with Sequence1 to Sequence5, and third and fourth columns containing ProductA and ProductB (which are different for each Sequence#).
I need to have fields in a form automatically fill with the products linked to the correct sequence# for importing data each week, and then automatically change to the next sequence# set for the next week's import; with an option to tick a box to not automatically change the sequence if the products were not changed that week.
Does that make sense? I've given an example below.
Can anyone help?