AnsweredAssumed Answered

help on filter out records

Question asked by tech@phillipit on Jul 28, 2016
Latest reply on Jul 30, 2016 by Storganise

Hi,

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.

 

For example,

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.

 

thanks advance

 

Greg

Outcomes