I am new to using deluge, figured it would be easier than building a database and etc from scratch, however I haven't been around html/scripting since 2005 so im a little outdated and not picking it back up as expected. I'll try my best to break down what I am attempting to do:

I have multiple forms being: Loads, Drivers, Invoices, Trucks, Trailers, etc.

What I am trying to do is:

The loads form has the information for the loads, including but not limited to Customer (look up), Load number (numerical, normally 9 digits long), Full Address of Shipper/Receiver, Dates of those respective loads and unloads, base rate (which im looking to populate to an invoice form upon creation of load), driver (lookup from Driver form), truck/trailer (lookup from Truck/Trailer forms)

The invoice form is basically a lookup of customer, rep, bill to, and then has OLI listed for various chargeable things (in example: base rate, extra stop, out of route miles, etc.) with a total.

The two things I am looking to accomplish is a workable invoice template (on demand invoicing) and more importantly a driver pay slip, with ease instead of tons of data entry and formatting. (been depending on excel for to long) 

I believe once I relate myself on one of those, the other coding process will fall into place.

Sorry for being all over the place, but this is what I am trying to accomplish for the driver pay slip. Each load has a load number, and an assigned driver, and pay detail coming from the invoice. I need to gather all of that information on one page (html template). So I would need the driver listed, upon listing him/her, all the loads for that driver for that respective week will populate (coming from the loads form) with payment details coming from invoice form.

Any ideas or thoughts?