D
dan.cawthorne
Hello all,
i was wondering if some one could point in the right direction,
Im trying to create a ductwork calculation program in access.
so far i have 3 tables
* tbl_Project
* tbl_Estimate
* tbl_Projects
tbl_Project consists of fields
ProjectID:
ProjectName:
Date:
Revision:
tbl_Estimate consists of fields
ItemID:
Qty:
Item:
tbl_Products consists of fields
ProductID:
ProductCode:
ProductType
ProductDescription
ProductSize
UnitCost
The Idea is the create i project, then with in the Estimate Section
can list all the ductwork, products which will be populated in the
tbl_Products
Eg
ProductID ProjectCode ProjectType Project
Description Size Unit Cost
1 | DUCTCIR100 | DUCTWORK | 100Dia Circular Ductwork
3M | 100 | £5.00
So the idea is to have a continuous form, with a sub form at the top
which have the Project Details at the top.
Then on the form I'll have following field:
ItemID: | Qty: | Item: (Select Lookup - from project
description) | Unit Cost | Total
I know Im not storing calculated fields this way, but what i would
like to do is when i select a item, the Unit cost also gets filled in,
and then when i input a Qty, the total would reflect, and then at the
bottom there would be a Grand Total of all Total Costs.
How does one achieve this?
Regards
Dan Cawthorne
i was wondering if some one could point in the right direction,
Im trying to create a ductwork calculation program in access.
so far i have 3 tables
* tbl_Project
* tbl_Estimate
* tbl_Projects
tbl_Project consists of fields
ProjectID:
ProjectName:
Date:
Revision:
tbl_Estimate consists of fields
ItemID:
Qty:
Item:
tbl_Products consists of fields
ProductID:
ProductCode:
ProductType
ProductDescription
ProductSize
UnitCost
The Idea is the create i project, then with in the Estimate Section
can list all the ductwork, products which will be populated in the
tbl_Products
Eg
ProductID ProjectCode ProjectType Project
Description Size Unit Cost
1 | DUCTCIR100 | DUCTWORK | 100Dia Circular Ductwork
3M | 100 | £5.00
So the idea is to have a continuous form, with a sub form at the top
which have the Project Details at the top.
Then on the form I'll have following field:
ItemID: | Qty: | Item: (Select Lookup - from project
description) | Unit Cost | Total
I know Im not storing calculated fields this way, but what i would
like to do is when i select a item, the Unit cost also gets filled in,
and then when i input a Qty, the total would reflect, and then at the
bottom there would be a Grand Total of all Total Costs.
How does one achieve this?
Regards
Dan Cawthorne