New guy needs help with some design

[lpkorn423]

Designing a database for a fabrication company. I think I have the relationships correct but I am unable to create justified reports. We need the database to print invoices, which I was able to do as a justified report in a prior design, but with the current breakdown of tables and relationships... I am unable to choose a justified report.



Summary of the data:
A job number has base information of customer, date, etc.

Each job has many 'lines'
JobLines include JobLineID, partID, quantity, price, weight

Invoices have many 'lines'

Lines include invoiceID and JobLineID

I've included a pdf of the relationships as they are currently. My biggest concern is being able to take all of this data (which does all relate correctly when viewed in a query) and create invoices.



Report1.pdf

[orange]

You may get some ideas from this free data model
http://www.databaseanswers.org/data_...ices/index.htm

[Rod]

A brief rejoinder regarding the developer's note in the link. He excuses himself for including derived data in the Invoice_Line_Items table. However he should not! Over time prices and/or VAT rates change and the line items show the values at the time of the invoice - a snapshot in fact valid for this invoice (and only this invoice).

Otherwise it's a very good standard model - thanks for the link.