Help - weird problem with option group

[rick]

I have a parent table and a child table. (literally - mothers/fathers and
babies).
In the child table there is an option group which displays/updates data in a
field called Guardianship. The options are from 0 to 4 - no default.
The table has the Guardianship field set as Number, Integer and default
value Null.

When a Parent registers on a program they may also place their babies in
Child Care.

However, if the Guardianship field is either Null or 4 a weird thing happens
in that the SQL does not find the Baby. If it is 0,1,2,or3 it does find the
Baby.

Any ideas would be helpfull. Thanks.

... rick

 

[KARL DEWEY]

Post the SQL.

 

[Guest]

If you are using SQL Server as the backend, avoid using null. Default it to
zero.
Try manually setting the Guardianship to zero, and see if the SQL picks it
up.

Cheers,
Bubbles