By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

Suggestions needed.

P: n/a
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

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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.