I have a system I use to track all the databases used in the company. In this I have a to do list. Each to-do has a check box for done. I want to be able to do a quick find for record that have un-done to-dos.

I tried making value list on a relation "toDoList_x" in a calc field like this:

Note: with my check boxes, on is "X"

If(

PatternCount(ValueListItems(Status(CurrentFileName), "toDolist_x"), "X")

<

Count(GL Database | zk.systemID_p # zk.systemID_f::zk.databaseID_p)

,

"0"

,

"1"

)

the idea was to then do a find on that field. Though, as it turns out, the value list based on related values filters out duplicates. So it does work if i have more then one to-do.

Anyone got a way to fix this or a new (and simple) way of doing it?

Relating to "toDoList_x" is what you really need.

Supposing you have a global field gToDo in your master file than create a relationship

toDos:gToDo-->toDoList_x"

Than simply use Aggregate functions to perform calcs like Count(gToDo::someField), Sum(gToDo::someField) or get db names thru conditional value list based on above relationship.

Dj