Solved: If Any function help - Page 2

School_Bus · 02-15-2020 03:16 PM

OK, so I’m lost and I’ve been struggling with figuring out how to write this for over an hour now. I have a record, and it creates multiple child records in another table. In that child record I assign a driver to the record. What I want to do is have a True False statement that tells me if there is a driver assigned to all related child records. I was thinking I could use an IF and an Any function to accomplish this, but I keep getting false Trues.

Does anyone know how to do this?

Thanks in advance for the help

tony1

How about something like this? COUNT(SELECT([Related Child Records][Child Key], ISNOTBLANK([Driver]))) = COUNT([Related Child Records])

The [Related Child Records] is the virtual column in your parent table that holds the related children.

View solution in original post