Method Community

In a Customer List I have added a new section called 'Invoice Line Items'. My goal is to have a grid which shows which items a particular customer has purchased.

First, I created two new linked fields in the InvoiceLine table called 'FullNameLinked' and 'SalesRepLinked'. These grab the respective info from the Customer table.

Then, I inserted a grid into the Customer List screen which lists items from the 'InvoiceLine' table (detached).

I then tried to automatically filter this grid by 'SalesRepLinked' using the logged in rep from the current session (this works by itself). However, when I try to further filter it by 'FullNameLinked' matching the 'FullName' value from the screen, I get no results.

What am I doing wrong? Is there a better way?

Alex,

You can actually use an attached grid on the Customer screen. This will work nice because each time you select or change a customer record it will display the properly filtered info. A relationship between the Customer table (the one the screen is built on) and the InvoiceLine table needs to be made. Add a dropdown field to the InvoiceLine table using the existing Entity table and choose FullName as the field.

You will need to put some actions on the invoice screen to update the newly added field on the InvoiceLine table for each line otherwise it will be blank and nothing will show up on the new grid. You can then add the sales rep to the InvoiceLine table as a linked field and easily filter the grid afterwards.

Hope this helps,

Alex,

Looking back at this you could still have the detached grid and add a linked field to the InvoiceLine table that gets the Customer from the Invoice table.  Then filter the grid by the full name and refresh the grid using actions on the select link.

Thank you. This worked fine (actually, I didn't quite follow the first suggestion). But, I'm not sure I understand why it needs to be refreshed while other filtered grids don't need to be?