Verify multiple related records on a child table

[FredFranca]

Hi Folks, This is my first post here.

I need a script that could verify if all records related to the parent table are true.

For example: I need to change a field in the parent table if all records from a specific related field in the child table are set as "ok".

Again ,I have a order (parent), and to send it, all products(child) must be available, so when all the items in the product list are set as "available" the script automatically sets the order (parent) as "ready".

Couldn't manage to do that with "if" function.

Any ideas?

[comment]

You could do this with a calculation =

Count ( Child::ParentID ) = ValueCount ( FilterValues ( List ( Child::Status ) ; "available" ) )

[FredFranca]

Hey! thanks for the quick reply.

Unfortunately still doesn't work properly. When ever any record in the field in the child (available) changes it switch the record in the parent.

I need to change only when All the records are set as available.

I see and understand the calculation but something still not working. I reviewed my database and looks allright.

Thanks again.

[comment]

Does this work for you?

ParentStatus.zip

[FredFranca]

Wow! It works perfect!

I was trying to put the Calc inside the script.

Many Thanks!