Problems with form

Hi all,

I have created 2 new checkbox in my InventTable. When both the checkbox are ticked, it will return the ItemId. I've wrote overwrite the 'modified' method for both the checkboxes and it will return the 'ItemId'.

The problem is when i checked on both the checkbox for item 'BR-14', it returns the ItemId correctly but when i checked on just one of the checkboxes for 'BR-6' it returns the ItemId as well.

How can i control this? I just want to return just one itemId when both the checkboxes are checked on every line in InventTable.

I hope that you can understand what i'm saying here.


Below is the method which i will call everytime i check or uncheck on the checkboxes.


void returnItemId()
{
InventTable _inventTable;
;

select firstOnly RecId from _inventTable
where checkPurch.value() == noyes::Yes
&& checkSales.value() == noyes::Yes;
info (InventTable.ItemId);

}