Hi again John.
- still nothing, maybe Jason can help when the USA wakes up later today.
Just thinking though, if the customer is likely to be adding/editing/deleting rows in the table on a regular basis, the premise of having a list conforming to a weekly change programatically seems to lose a bit of control.
what if the customer decides they want list 3 this week, then list 7 and then list 14 ?
At first, I thought a fixed standard list, with the possibility of new rows would work well, but if the list is essentially dynamic, wouldn't a flag for the active list, (i think shown in your original structure), be more appropriate ?
Just a thought.