K
Key Powell
Hello all,
I am trying to create a database that allows me to bid new jobs based on
previous model homes.
(example: a contractor has a model home named AX that is built multiple
times. He informs me that he is building an AX for a specific buyer at a
specific location and assigns the job name U71 T59E. He also informs me that
there are some fixture upgrades for the job)
I want to be able to pull up a previously saved model (AX), duplicate it,
then make changes to the fixtures and calulate a new job total. I also use
the Job details for scheduling latter.
Here is how I have things currently set up:
tblJobSiteDetails:
Job Name
rimary Key
Address:
Contractor:
Etc.
tblJobSiteFixture:
AutoNumber: Primary Key
Job Name: References JobSiteDetails
Fixture Option: References Fixture Prices Query
Fixture Quantity:
tblFixtures:
Fixture Option: Primary Key
Fixture Details:
List Price:
qryFixturePrices:
Fixture Option:
List Price:
Discount: (Looks up rate from another table)
Markup: (Looks up rate from another table)
Contractor's Price: Calculated
qryJobPrices
Job Name: (Looks up from tbleJobSiteDetails)
Option: (Looks up from tblJobSiteFixtures)
Price: (Looks up from qryFixturePrices)
Quantity: (Looks up from tblJobSiteFixtures)
Fixture Total: Calulated by multiplying Price and Quantity
qryJobTotals:
Job Name: (Looks up from qryJobPrices)
Contract Price: Summary Total of qryJobPrices
I beleive this is all the information required. I greatly appreciate any
help available.
Thank You,
Key Powell
I am trying to create a database that allows me to bid new jobs based on
previous model homes.
(example: a contractor has a model home named AX that is built multiple
times. He informs me that he is building an AX for a specific buyer at a
specific location and assigns the job name U71 T59E. He also informs me that
there are some fixture upgrades for the job)
I want to be able to pull up a previously saved model (AX), duplicate it,
then make changes to the fixtures and calulate a new job total. I also use
the Job details for scheduling latter.
Here is how I have things currently set up:
tblJobSiteDetails:
Job Name
rimary KeyAddress:
Contractor:
Etc.
tblJobSiteFixture:
AutoNumber: Primary Key
Job Name: References JobSiteDetails
Fixture Option: References Fixture Prices Query
Fixture Quantity:
tblFixtures:
Fixture Option: Primary Key
Fixture Details:
List Price:
qryFixturePrices:
Fixture Option:
List Price:
Discount: (Looks up rate from another table)
Markup: (Looks up rate from another table)
Contractor's Price: Calculated
qryJobPrices
Job Name: (Looks up from tbleJobSiteDetails)
Option: (Looks up from tblJobSiteFixtures)
Price: (Looks up from qryFixturePrices)
Quantity: (Looks up from tblJobSiteFixtures)
Fixture Total: Calulated by multiplying Price and Quantity
qryJobTotals:
Job Name: (Looks up from qryJobPrices)
Contract Price: Summary Total of qryJobPrices
I beleive this is all the information required. I greatly appreciate any
help available.
Thank You,
Key Powell