I need to ‘associate’ a day of the week to a market.
The problem is this:
If a day (relative to a market) has already been been ‘allocated’ then you can’t allocate that day again.
So Rag Market can’t have two Monday’s etc
I thought of a unique datatype but that’s not the answer as it needs to be relative to the Market selected in the drop down. Setting the day as ‘unique’ would prevent you from selecting Open Market - Monday and Rag Market Monday.
Does anyone know how to do this please?