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 hav...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendStu, you have described your tables, but I'm not understanding what your specific question is.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
Thank you for responding and my apologies for being unclear.
What I'm trying to accomplish is that each time I create a new record in the Employees Table and select the Asus USB Monitor checkbox and save, I want it to add a value of 1 to x for the Asus USB Monitor record in the Inventory Table.
If I create three records in the Employees Table and select the Asus USB Monitor checkbox and save, I want there to be a value of 3 in the x field associated with the Asus USB Monitor record in the Inventory Table.
If I uncheck the Asus USB Monitor checkbox in the Employees Table for one of the records I've previously saved, I want the Inventory Table to update so that the value is now 2 in the x field associated with the Asus USB Monitor record in the Inventory Table.
Thank you,
Stu
- MarkShnier__You
OK. One Equipment has Many Employees.
I think all you need to do is to create a summary field on that Relationship to count the # of Employees with a filter to only include where Asus USB Monitor checkbox is checked.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Mark,
Thank you for your response. I tried your suggestion, but I'm still running into an issue. The attached pdf provides a bit more detail if you don't mind taking a look.
Stu
------------------------------
Stu Lamden
------------------------------
