C
Craig Armitage
Hi,
I would like to generate a printable invoice based on job data in my
database.. basically, i have 3 tables.. Jobs, Customers and JobsPartsUsed
Relating to this problem, the tables have the following fields..
Jobs table
----------
JobsID (pk)
CustomerID (fk)
JobReport
Customers table
----------------
CustomerID (pk)
CustomerName
CustomerAddress
JobsPartsTable
----------------
JobsPartsID (pk)
JobsID (fk)
JobsItemDescription
JobsItemCost
JobsItemQuantity
Ok, hopefully you can see that i want to generate an invoice based report
that shows the customers details at the top, then the JobReport and finally
a list of any parts used in the job.
I cant seem to get the JobsPartsTable to only show the parts related to the
JobsID.. it always shows all the parts.
How would you guys set this up?
Also, on a slightly different note, i would like to calculate the sub totals
of each of the items in the list.. is the best way to have a field called
subtotal and get it to be filled in on an changed event for the qty/cost
fields?
Thanks in advance for any help given..
Craig
I would like to generate a printable invoice based on job data in my
database.. basically, i have 3 tables.. Jobs, Customers and JobsPartsUsed
Relating to this problem, the tables have the following fields..
Jobs table
----------
JobsID (pk)
CustomerID (fk)
JobReport
Customers table
----------------
CustomerID (pk)
CustomerName
CustomerAddress
JobsPartsTable
----------------
JobsPartsID (pk)
JobsID (fk)
JobsItemDescription
JobsItemCost
JobsItemQuantity
Ok, hopefully you can see that i want to generate an invoice based report
that shows the customers details at the top, then the JobReport and finally
a list of any parts used in the job.
I cant seem to get the JobsPartsTable to only show the parts related to the
JobsID.. it always shows all the parts.
How would you guys set this up?
Also, on a slightly different note, i would like to calculate the sub totals
of each of the items in the list.. is the best way to have a field called
subtotal and get it to be filled in on an changed event for the qty/cost
fields?
Thanks in advance for any help given..
Craig