>Naomi,
>
>I think you're too close to the problem. You're making things more complicated than they need to be. Let's simplify...
>
>The problem isn't with entering the data, it's with interpreting it. Simply set up your option group with Monday, Tuesday, etc. as 1, 2, 3 and so on.
>
>When it comes time to interpret it, simply something like
IF MyTable.DayOfWeek = DOW(DATE(), 2) THEN
> * Do your processing.
>ENDIF
The process to deal with the nDow is not even going to be mine and I do not want to do extra conversion that time. nDow = 2 should mean Monday, and not nDow=1. I believe that using unvisible option 1 is the simplest solution to this problem.
If it's not broken, fix it until it is.
My Blog