Time Box controls check box and vice versa

[Pusher]

How can i make a date box control a check box. If i enter the end time - the UNFINISHED check box cant be checked. If the UNFINISHED check box is checked the end time cant be entered.

Thanks

 

[Galaxiom]

Normally both would not be recorded in a table. The presence of the date would indicate that it is Finished in any query or report.

 

[Pusher]

I just wanted to make it easier for the people in the enter form not to make a mistake

 

[Galaxiom]

If you record a date then surely by definition the record is Finished. If there is no date the record is Not Finished. There is no need for the Finished checkbox at all.

Your requirement to prevent the conflict of the two fields is best solved by not including the Finished field at all. Then the operator can't enter an illegal combination. This is one the central principles of database normalization.

If the system needs to know if a record is Finished then it simply checks for the presence of a date. Date present means Finished. No date means Not Finished.

Is there some part of the problem I have misunderstood?