I have a table, lets call it Customers. Each customer has an address, phone number, etc. This is represented as a Straight Table with the customer ID as the dimension.
I want a solution where I can click on a customer, and another straight table will appear (Ill do getSelectedCount here), and this new table will list the customers who have the same phone number, or same address, or same whatever other attribute, as the selected customer.
Can anyone guide me as to how this might be implemented?
1) Can you explain this expression a bit? Im having trouble understanding it (even though it works!)
2) Can I perform the same 'lookup' on another unconnected table? So if I click a Customer, it will show me all my Debtors with the same phone number, for example. Assuming Debtor is a similar table to customer, just a different entity. I'd like to avoid a seperate linking table!