Conditional formatting based on boolean summary?

[emncwundy]

I am not sure of best way to explain this, and i am feeling a bit overwhelmed with the concept of boolean values, but here goes...

I have an 'orders' databse which contains 'order line items'.

suppliers often deliver only part of an order. I want to conditionally format a parent record (order) for which delivery is incomplete.

So far my thinking is as follows:

in the line items have created a boolean value for 'delivered'. I want a summary field to total the number of items on the order that have been delivered and a summary field to count the order items. So if items delivered - items counted = <0, then the order (parent record) is still PENDING.

I have managed to get the count to work, but not the total of delivered.

Any suggestions?

[comment]

I want to conditionally format a parent record (order) for which delivery is incomplete.

Try =

Count ( OrderLineItems::OrderID ) > Count ( OrderLineItems::Delivered )

IMHO, Delivered should be a Date field.

[emncwundy]

Thank you! Such a simple and clean solution. I can see I have lots to learn still.

re the date field - i can see the value in your suggestion. I would like to create a button that automatically enters todays date into it when clicked. is there a shortcut for this?

[comment]

Make the button:

Set Field [ OrderLineItems::Delivered ; Get (CurrentDate) ]