"jeff" <no**********@spm.com> wrote in message
news:tZUNd.54709$EG1.42573@attbi_s53...
I'm trying to build a Quote program. I have looked at several threads but
still confused.
What I need is to be able to enter materials and labor. Both material and
labor have had codes assigned to them. Materials have a cost assigned to
them and labor has an hourly rate assigned. I have built tables for each
Labor
Materials
Quote Details
Hi Jeff,
There should also be an Invoice table. As I see this, there would be an
Invoice Form with a Subform, and that Subform would be Order Details.
Combine Labor and Matierials into one table and add a checkbox for taxible
(if you charge tax)
Tables:
-----------
Invoice
Invoice Details
Labor-Matls
You can do your calculations in the query and then bind the fields on the
form to data fields in the query. Be mindful of which calculations you make
on-the-fly and which data is stored in a table. For example, if you raise
your labor rate six months from now, you would want any old invoices that
you open to not calculate values based on your new labor rate.
The main problem I'm having is using subforms in order to input
information for both labor and materials. Should the subforms be based on
tables or queries? There are several calculations that will need to be
done I assume they would be done in a query, is that right?
Any suggestions or commits would be appreciated.
Take it one step at a time. Do you have the Primary Key/Foreign Key thing
figured out?
Mike