F
FerryMary
Using:Access 2003
(I'm not even sure how to ask this, so patient people only probably need to
proceed)
Situation:
Portion of my database deals with preventive maintenance performed to vessels.
Originally I was instructed to utilize the database to create a library of
sorts dealing with equipment on a fleet of vessels. Followed by a general
table for entry that the maintenance had been completed, hours at time of
service etc.
To keep from having to repeat Prev.Maint items for each vessel I set up the
following:
tblfleet
tblvesselCompartment(main engines, bow Thrusters, steering etc)
tblVesselEquipment(specific equipment with serial numbers, Maintenance
Reference*)
*tblMaintRef(Lists Maintenance Categories)
tblPreventive Maintenance List(ex. 'Check Air-Box Shutdowns')
tblPrev Maint Ref(ex.'pg 20 of disassembly and assembly publication #
SENR2377-02)
Using a query with find records by Vessel ID I can create this nifty report
for a full Preventive Maintenance Systems Check for all systems per vessel.
NOW, my problem. Since alot of the preventive items and references are the
same for various vessels and peices of equipment I used the set up listed
above, because I was told that a general service report showing service was
complete was what we wanted. Now, I'm told that what we want to be able to
do is follow the list using the computer and check-off each item, date,
person responsible and comments.
Obviously I'll need a table to hold the information and I have a handle on
which fields I need. I've already copied and modified query involved. But
am unsure how to use a form to pull the worklist, add the results and save
ALL(?) to a table.
Just typing it out is giving me a few new ideas. But time is my enemy this
week and any help would be most appreciated.
Thanks so much
(I'm not even sure how to ask this, so patient people only probably need to
proceed)
Situation:
Portion of my database deals with preventive maintenance performed to vessels.
Originally I was instructed to utilize the database to create a library of
sorts dealing with equipment on a fleet of vessels. Followed by a general
table for entry that the maintenance had been completed, hours at time of
service etc.
To keep from having to repeat Prev.Maint items for each vessel I set up the
following:
tblfleet
tblvesselCompartment(main engines, bow Thrusters, steering etc)
tblVesselEquipment(specific equipment with serial numbers, Maintenance
Reference*)
*tblMaintRef(Lists Maintenance Categories)
tblPreventive Maintenance List(ex. 'Check Air-Box Shutdowns')
tblPrev Maint Ref(ex.'pg 20 of disassembly and assembly publication #
SENR2377-02)
Using a query with find records by Vessel ID I can create this nifty report
for a full Preventive Maintenance Systems Check for all systems per vessel.
NOW, my problem. Since alot of the preventive items and references are the
same for various vessels and peices of equipment I used the set up listed
above, because I was told that a general service report showing service was
complete was what we wanted. Now, I'm told that what we want to be able to
do is follow the list using the computer and check-off each item, date,
person responsible and comments.
Obviously I'll need a table to hold the information and I have a handle on
which fields I need. I've already copied and modified query involved. But
am unsure how to use a form to pull the worklist, add the results and save
ALL(?) to a table.
Just typing it out is giving me a few new ideas. But time is my enemy this
week and any help would be most appreciated.
Thanks so much