I have a table (CustomerItem) with data obtained by using a conditional value relationship. The table lists all the products that each client buys from me. The problem is when I create a relationship between CustomerItem and InvoiceData (table that holds the data for each client invoice).
I was hoping when I use a popup in InvoiceData portal, it would list only the products that that client buys, but it does not. It shows all the models in the CustomerItem tabel.
The link between the 2 tables is (InvoiceData - IDf_CustomerID) and (CustomerItem - IDf_CustomerID).
CustomerItem is linked to Customer table by ID_CustomerID (unique value).
Any help would be appreciated. It is driving me nuts.