Example:
Table: Test
Fields: RequiredData BOOL and DefaultData INT

Write a Constraint check for verify:

If FieldRequiredData = True Then DefaultData cannot be NULL.

Vitor Martins

Vitor



ALTER TABLE "Test"
ADD CONSTRAINT "TEST" CHECK ((FieldRequiredData = FALSE) OR (DefaultData IS NOT NULL))

I think if I understand your post correctly

Roy Lambert [Team Elevate]