I have two tables: Primary table called Payments and secondary table called Invoices.

**Payment Table fields**

- Customer number
- Amount

**- [Customer number] [Amount]***concatenated*

**Invoice Table fields**

- Customer number
- Amount
- Invoice number
**[Customer number] [Amount]***concatenated*

I may have 3 payments for a given customer that I need to match to an invoice number; however, there may be 5 invoices. I want to look up 3 of the 5 invoices to find the corresponding invoice number.

My problem is that when I combine tables, I get all 5 invoices because they all match my primary key ([customer number] [amount] *concatenated*).

Is there a way I can tell Parabola, if I have 3 records in one table, do not find more than 3 matches in the corresponding second table?

This is driving me nuts!

Thank you for any help you can provide!!