darrelhawes
Technical User
I am designing a simple database to track equipment usage information. We maintain a fleet of construction equipment that is charged out to construction projects based upon hours used, subject to a minimum amount of hours. The minimum amount of hours is different for each piece of equipment.
I have a table which lists the following information:
Equipment Number
Equipment Description
Rate
Minimum
I have a form built to input the usage data. Included on the form is a combo box in which the user can select the equipment number.
Here's my quandry:
In my "Transaction" table, is it better to:
A. Store the Equipment Number, usage amount, rate, and minimum, in which case the computation of amount charged for that equipment can be computed on reports, or
B. Store the equipment number and amount charged.
I realize that a third option could be to just store the equipment number and usase hours, and then look back at my equipment table for the rate when printing reports. However this is not a viable solution since some of these construction projects span several years and the rates will change during that time frame.
Darrel
I have a table which lists the following information:
Equipment Number
Equipment Description
Rate
Minimum
I have a form built to input the usage data. Included on the form is a combo box in which the user can select the equipment number.
Here's my quandry:
In my "Transaction" table, is it better to:
A. Store the Equipment Number, usage amount, rate, and minimum, in which case the computation of amount charged for that equipment can be computed on reports, or
B. Store the equipment number and amount charged.
I realize that a third option could be to just store the equipment number and usase hours, and then look back at my equipment table for the rate when printing reports. However this is not a viable solution since some of these construction projects span several years and the rates will change during that time frame.
Darrel