>>Naomi,
>>
>>I'm lost. My solution was based on there being a date field. Now I don't know what to think. The solution could be as simple as your using SET FDOW TO 2 or doing some modulus 7 arithmetic.
>>
>>If you tell me what you're trying to do here with the numeric field, it would help.
>
>We schedule batch processes to run in the particular day of week. Say, on Monday we're running Letter processing, on Tuesday - UB printing, etc. So, in my table I store the day of week I want to run the process. We want to run the processes only on work days, since on Saturday and Sunday Network administrators run different administrative tasks. So, I put an option group on the form and create options with captions from Monday through Friday. I want to store number of the day in my table. I don't want to do any additional transformation with this number, e.g. Monday is 2, Tuesday is 3, etc. So the simplest solution here is to add an additional option number one (Sunday) and make it invisible.
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
ENDIF
George
Ubi caritas et amor, deus ibi est