Use a IIF statement??

[jemery0630]

Have two fields - Not Complete [Y/N] and Date [mm/dd/yyyy]

I want to make sure they both can not be defined at the same time

If Not Complete is Y, then Date must be Null -or-
If Date is defined, then Not Complete must be "N"

Date is null and Not Complete is null could also exist

Thanks

 

[jemery0630]

Its similar, not redundant.

The Yes/No field shows that Construction is not complete but has no
scheduled Construction date

Construction Complete date is filled in when it is scheduled. At that time,
i want the yes/no field to default to no.

I was origianlly adding a date way out in the future (1/1/2100), but wanted
to eliminate the possible issued when that date does arrive.

You should just have the ONE field (the date field) and if it isn't filled in
it is incomplete and if it is it is complete. You are trying to store
redundant data anyway by trying to use two fields, so don't have the Yes/No
field. You can always DISPLAY a checkbox based on if there is a value in the
date field or not.
--
Bob Larson
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

Have two fields - Not Complete [Y/N] and Date [mm/dd/yyyy]

I want to make sure they both can not be defined at the same time

If Not Complete is Y, then Date must be Null -or-
If Date is defined, then Not Complete must be "N"

Date is null and Not Complete is null could also exist

Thanks