Method Community

Hi - I have a screen with 2 grids, one contains information from the Invoice table and the second pulls from the InvoiceLine table. They both contain the 'RefNumber' field from the Invoice table. What I want to do is create a button that has actions that filter the grids to only display the invoices that are checked off in the Invoice grid. What series of actions can be used to do this? 

In other words, I want to be able to select the rows in the Invoice grid that I want to view, then click a button that will filter both grids to only display the rows that are checked off in the Invoice table.

Thanks, Birch

Hi Birch,

One idea is to create a hidden field on the screen and upon clicking a button build a list of RecordIDs from the selected invoices and place it in that hidden field. On the second grid have it filter by value from screen and filter it by the contents of the hidden field.

-Michael