Show Count of Invoices

[#1]

Hello!

I have a table that contains a list of backorders. Each of this has an associated Account Number, Product, and Invoice number. I have a second table that contains a history of posted invoices. I am trying to get a textbox to display the count of invoices for a specific customer based on the product that is currently on backorder for them.

Backorder:

     Customer - A

     Product - X

     Invoice - 100

I want to find every invoice where A has purchased X. I attempted to use Set Analysis in several ways but I keep getting results that pertain to the selected Backorder alone.

I attached the table structure to assist in representing my model.

[settu_periasamy]

If the fields are properly linked, try some think like

=Count({<Customer={'A'},Product={'X'}>}Invoice)

-> The above will give the result including duplicate value. If you don't want you can use 'Distinct'

-> Fields are case sensitive, give the exact Field you are using.

[#3]

Does this work if I need "A" and "X" to be derived from the selected record? For example, can I use the field name "Account" that corresponds to the field name "Customer" from a different table?