I want to lookup a record in my contracts table based on 2 fields in my invoices table.
In our example we have a contract with the client, so I have a table with the client name and contract start date and end date. A client can have more than one c...