The forms address are in the attach pic
These are maintenance forms for vehicles.
The forms currently posts all data and the dbase has been created.
The forma have two areas that need to be addressed
“Tire Needs Replacement”
“Tire changed”
The vehicle has tires that need to be periodically replaced due to damage as well as replaced on or before the recommended tire manufacture mileage. In addition to extend the life of the tires they need to be rotated at a specified mileage.
The form has select buttons which allowing a user to set the button marking the need to be replaced setting a boolan to 1 in the EQUIP_MAINT table. From that point every time the form is opened the tire button shall remain on until the same tire is marked as changed.
Also based on manufacture recommend mileage the button can be set to change without user input. When the mileage gets within 5000 miles from the TRUCKS table in the blank area at the bottom left the user should receive a message in black counting down the mfg mileage. If the mileage is exceeded the message will appear in red.
The message should read
“The (tire_variable) needs to be replaced”
This will occur for each of the 6 tires
When the tire is marked as changed the boolan from the EQUIP_MAINT will be set to 0 and the mileage will start to count down again based on the tire change mileage in the TRUCKS table. Also when the tire is marked as changed the message above will no longer display.
As mentioned the tires also need to be on a rotation schedule. This schedule shall be based on fields in the TRUCKS table. When the mileage gets within 3000 miles from the TRUCKS table in the blank area at the bottom left the user should receive a message in black counting down the rotation mileage. If the mileage is exceeded the message will appear in red.
The message should read
“The (tire_variable) needs to be rotated”
This will occur for each of the 6 tires
When the tire has be marked as rotated the Boolan in the EQUIP_MAINT table will be set to 1 and the message will no longer appear as well as the mileage count down will begin again based on the field in the TRUCKS table.
On the form there is also a place for trailer tires that will need to be changed and replaced as well.
The form has select buttons which allowing a user to set the button marking the trailer tires that need to be replaced setting a boolan to 1 in the EQUIP_MAINT table. From that point every time the form is opened the tire button shall remain on until the same tire is marked as changed.
When the tire is marked as changed the boolan from the EQUIP_MAINT will be set to 0 and the mileage will start to count down again based on the tire change mileage in the TRAILERS table. Also when the tire is marked as changed the message above will no longer display.
The message should read
“The (tire_variable) needs to be changed”
This will occur for each of the 4 tires
When the tire has be marked as changed the Boolan in the EQUIP_MAINT table will be set to 1 and the message will no longer appear as well as the mileage count down will begin again based on the field mfg_milage in the TRAILERS table.
The following are a Boolan in EQUIP_MAINT table
trailer_drv_front_replace
trailer_drv_rear_replace
trailer_pass_front_replace
trailer_pass_rear_replace
trailer_drv_front_changed
trailer_drv_rear_changed
trailer_pass_front_changed
trailer_pass_rear_changed
The following are varchar in the TRAILERS table
trailer_drv_front_mfg_milage
trailer_drv_rear_mfg_milage
trailer_pass_front_mfg_milage
trailer_pass_rear_mfg_milage
Below are the fields all ready created in the dbase and their type
Tire Needs Replacement – the following are Boolan in the EQUIP_MAINT table
drv_front_replace
drv_rear_replace
drv_rear_inner_replace
pass_front_replace
pass_rear_replace
pass_rear_inner_replace
Tire has been Changed – the following are Boolan in the EQUIP_MAINT table
drv_front_changed
drv_rear_changed
drv_rear_inner_changed
pass_front_changed
pass_rear_changed
pass_rear_inner_changed
Tire Change Schedule – the following are varchar in TRUCKS table
drv_front_tire_change_milage
drv_rear_tire_change_milage
drv_inner_tire_change_milage
pass_front_tire_change_milage
pass_rear_tire_change_milage
pass_inner_tire_change_milage
Tire Rotation– the following are varchar in the TRUCKS table
drv_front_tire_rotation
drv_rear_tire_rotation
drv_rear_inner_tire_rotation
pass_front_tire_rotation
pass_rear_tire_rotation
pass_rear_inner_tire_rotation
The following are Boolans in the EQUIP_MAINT table
drv_front_tire_rotated
drv_rear_tire_rotated
drv_inner_tire_rotated
pass_front_tire_rotated
pass_rear_tire_rotated
pass_inner_tire_rotated