If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vehicle Waiver Database
I need help in creating a solid table structure for tracking vehicle waivers.
I posted this before, but I cannot find the related post. I will try to give as much detail as possible. Scenario: A vehicle maintenance shop needs to keep track of all items on a vehicle that will not be repaired due to cost effectiveness, non safety related or cosmetic items (minor dents and scratches, cracks in the dash, non-essential light inop and so on). These items that will not be repaired are waivered on a form that is kept in the vehicle. It is also the maintenance shops responsibility to send a report quarterly to each vehicle control officer of all waivered items for their vehicles. Details: Vehicles are assigned to a unit and each unit is designated by a master code. Each unit can have offices assigned and they are designated by a sub-code. In addition, the master code can also be used as a sub-code (i.e. Civil Engineering is master and shop within, like, A/C, water, roads and grounds are subs). Each unit has a vehicle control officer assigned to it who will receive the quarterly waiver report for their unit. Each vehicle is assigned a unique registration number and waivered items are strictly unique to each vehicle. Here is what I have so far: tblOrgs: MasterID (PK) MasterOrgCode OrgName Address UserCode1 UserCode2 UserCode3 UserCode4 UserCode6 UserCode7 UserCode8 tblUsers: UserID (PK) UserCode MasterID (FK) from tblOrgs UserName VCOID (FK) from tblVCO tblVCO: VCOID (PK) MasterID (FK) from tblOrgs VCOName Phone tblVehicle: VehicleID (PK) RegNumber MGMTCode UserID (FK) from tblUsers tblWaiver: WaiverID (PK) VehID (FK) from tblVehicle WaiverDate ItemWaived Initials (FK) from tblInitials tblInitials: InitialID (PK) NameLast NameFirst ManNO Initials I hope I gave enough info and thanks for taking the time to dredge through this. -- Ron A. |
Thread Tools | |
Display Modes | |
|
|