Hi,
I need your help.
I have 3 lists: Product, rate, invoice

and two modules:



I want to put in invoices.valid rate the max number# of rate list where all following conditions are satisfied:
- Rates.status = true
- Invoice.Prod name = rates.prod name
- Rates.start date < Invoice.Invoice date < rates.end date
Can you help me?
Thanks