Table Relationships and Checkboxes

Hello everyone!  

I was hoping that someone here could help me figure something out with my latest Quickbase App involving Table Relationships and Checkboxes.  Thank you in advance!

I have two tables.  One called Employees and the other called Inventory.

In the Employees Table/Form I have a checkbox called Asus USB Monitor and a Numeric field called Asus USB Qty.

In the Employees Table I have two Dynamic rules. 

1.       When the Asus USB Monitor checkbox is checked, set the Asus USB Qty to 1.

2.       When the Asus USB Monitor checkbox is unchecked, set the Asus USB Qty to 0.

I have created a relationship where the Inventory Table is the Parent and the Employee Table is the child.

I believe I need to add a Summary Field to the Parent table.  Let's call that field x.

The Employee Table includes the following:

Field Name -> Value

Inventory -> Yes

Description -> Asus USB Monitor

Total # of Items in Inventory -> 100

# of Items in Use->

# of Items Available-> [Total # of Items in Inventory] –

I have been able to use similar logic and it worked exactly as expected when the item selected from the Employees table is a Text - Multiple choice field. 

I just can't get it to work with a checkbox. 

Any help would be very much appreciated!

Thank you again!
Stu