So, numbskull that I am, I assume that there is a simple method to my issue.
In my solution, I will be creating a new invoice every month based on manually entered prices contained in a lease.
How do I generate an invoice, which pulls the correct information from the Lease???....
A lease can contain up to 6-10 products/services with a specific price.
Products/Services - List of Products - No prices per product
Leases - contains prices
instead of scripting a find for the price, and then setting the field price in the Invoice_Lines table. Is theres a better way of creating a relationship that will allow some type of look up for the price?