simple calculation logic

[ddreese]

I have a simple calc field that is used for 'alerts' to the user so they know what information is missing. I have two fields that are on the layout that are from a related record, one is 'wedlock' and the second one is 'mothers_name'. Wedlock is a yes/no, and the mothers name is a plain text field. I have something in my calc field as follows:

if ( relationship1::wedlock = "", "Missing wedlock yes/no", "") &

^^ That part works fine ^^

if ( relationship1::wedlock = "Yes" and relationship1::mothers_name = "", "Missing wedlock details", "")

Ultimately there are 3 other fields that I would like to include that in statement that if wedlock is yes and if any of the other fields (all text fields) are blank, then display "Missing wedlock details". The logic works with just the relationship1::mothers_name = "" part, but when I put it together with the first part it doesn't work. I've tried parenthesis all over the place to somehow make it more friendly, as well as a case statement... I just don't understand what is wrong with my logic? I've also tried to use the length() and isempty() functions, neither worked. I know it's gotta be something simple. Any help would be appreciated.

[comment]

Try:

Case (

IsEmpty ( relationship1::wedlock ) ,

"Missing wedlock yes/no",

wedlock = "yes" and (

IsEmpty ( relationship1::mothers_name ) or IsEmpty ( relationship1::detail2 ) or IsEmpty ( relationship1::detail3 ) or IsEmpty ( relationship1::detail4 )

),

"Missing wedlock details"

)

[ddreese]

Nope, seems to be the same deal, it just ignores the and, it seems? I don't get it I must be doing something really stupid... but I checked the fields, they are all blank and all the correct relationship... I'm baffled

[ddreese]

I knew it was something stupid. I forgot I was going to set the wedlock field up as a checkbox instead of yes/no... so it was a number field, that was the problem... I'll go crawl back into my hole, now