Not sure from you post why the calc you have setup would not work, could you post into on the 'total_lifeins_count' calc and how the relationships are setup between RESIDENTS and the LIFE INSURANCE TABLE?
One thing tro try though is to set your X field to look directly at the same source your 'total_lifeins_count' instead of the count, so try:
If ( not IsEmpty ( Residence_LIFE INSURANCE TABLE::UniqueID ) ; "X" ; "" )
Resedence_LIFE INSURANCE TABLE is the name of whatever table you have set to link RESIDENCE to the LIFE INSURANCE TABLE
Hope this helps in some way.
As always, thank you for the assistance.
It stil does not work. Very odd. I placed a copy of the total_lifeins_count field onto the layout and when I entered a new policy, it came up with a 1. I tried change from ISEMPTY to a numbe calculation of > 0. Still, the X persists. This is one of those situations where I think I may be changing so many things to debug it that I have created a royal mess.
I tried your answer as well. ... Still, the X will not go away. If you think of anything else, please let me know.
Thank you again.
> I HAVE A FORM THAT HAS A SIMPLE BOX THAT READS NONE (with a square next to it to check)
So you have a value list of only a value, "none", attached to a calculated field formatted as a checkbox.
> MY CALCULATION IS: Case ( RESIDENT::total_lifeins_count = "" ; "X" ; "" )
Try: Case( IsEmpty ( RESIDENT::total_lifeins_count ) ; "none" )