Table structure

[bridgeman]

I am having trouble getting my tables organized for their intended purpose. I
am wondering if I am breaking them down too much.
My first table is called:
tblPMList and contains the following fields:

MaintencanceID (This is an auto number and also the primary key)
txtStructureNumber (4 unique numbers)
txtStructureName
txtPMCode (280 PM activities assigned to the structures, some unique, some
alike)
txtPMDesription (describes the work for the PM Code)
txtPMType (Either mechanical or electrical)
txtEquipmentNeeded (what equipment is needed to preform the PM)
txtPMFrequency (1, 4, 8, 13, 26, 52, 104 represent the frequency in terms of
weeks)

This table I have disected into several tables,
One table for each of the 4 structures containing the following fields:
txtPMCode (this is the primary key and is the relation to the field in the
above table)
txtStructureNumber
The reason I did this was to separate the structures and identify what PMs
are performed for each.
I also created some Date tables for each of the structures that contain the
following fields:
txtStructureNumber
txtActCode
dPMDateDue
(the above 3 fields are a composite key combo in this table)
dPMDateComplete
What I need is some advice on where to go from here or if I am going to far
along and not going in the right direction.
The db is for a Preventative maintenance program that I am trying to develop
to get our program out of file cabinets and into the 21st century.
Thank you in advance
Cordially,
Jason

 

[bridgeman]

Pieter,
Thank you for the advice. Is there any way that I would be able to post a
snapshot of my relationships to these sites? I think that that would be the
best way for you to see what I am doing. The process is designed to model a
preventive maintenance program to be able to schedule the work based upon the
frequency required. Also with the ability to store historical, and project
future work.
Cordially,
jason P

 

[Marco Pagliero]

Pieter,
Thank you for the advice. Is there any way that I would be able to post a
snapshot of my relationships to these sites? I think that that would be the

You can try imageshack: http://imageshack.us/
You must register, then you can upload files and get an URL which you
can post here.

 

[Sandra Watmough]

Pieter,
Thank you for the advice. Is there any way that I would be able to post a
snapshot of my relationships to these sites? I think that that would be
the
best way for you to see what I am doing. The process is designed to model
a
preventive maintenance program to be able to schedule the work based upon
the
frequency required. Also with the ability to store historical, and project
future work.
Cordially,
jason P