I have a table with some records. in regular layout all records will be shown one by one. Now I want to create one special layout only shows some of these records base on one specific condition, like some field is empty or the example below.
table A has: ID; NAME; QTY_NEEDED; QTY_INSTOCK; _fk_TABLE_B_ID
table B has: ID; TIME_RECEIVING; QTY
tableA::QTY_INSTOCK = SUM(tableB::QTY)
I want a layout for table A which only shows records with qty_needed greater than qty_instock.