Query by Association of Tables

[juan_cruz_albornoz]

Hello everyone, I am new to the community, it is a pleasure to be in contact.
I'm from Buenos Aires, Argentina. I work in the Qlik department of a company that finances loans to buy cars.

I find the following problem, I have a table called "LoanInstallRow", which contains a field called InstallNr which is the loan installment number. And I have another table called "Payments" that has a field called "Fee Paid".

The question is: How can I link "Fee Paid" with "InstallNr" to verify the payment of the fee.

That is, link both tables to bring the relationship between them.

Thank you very much, I hope I can get some answer. Greetings

Juan Cruz Albornoz

[rwunderlich]

There must be some field in the payment table that associates the payment with a loan.  What identifies which loan the payment is for?

-Rob

[juan_cruz_albornoz]

Thanks!

"Payments" is related to "Loan", by means of the "loan number". And "Loan" is related to "LoanInstallNr" by "MasterID". Is a direct relationship between "Payments" and "LoanInstallRow" necessary?

Greetings

[rwunderlich]

A direct relationship is not necessary. You can bring in a third or more tables that create the linkage.