table help

[teiben]

Could someone offer me some advice, I need to build a db w/tons of info and I'm getting confused the more I read about data normalization.... I will have 5 plants enter a ton of data each day -date- (#25 staffing numbers; #10 quality numbers; #5 customer service numbers; #50 production numbers) everything in ( ) I need for each plant and each day; It seems to me that there are no one to one relationship, rather many to many? Help

 

[neileg]

Not enough information. Please explain in more detail.

 

[teiben]

Attached is a screen shot of all the fields. Ea day there will be 5 entries (one for each plant) for all values in the common field. In addition each plant has to enter info based on the process that they run; eg Fla (plant) my run 4 different processes (process field is in the tblManuf. My question is what type of relationship do I need? Many to many? also don't I want the ID value from each table to be stored in the table of the other, so I know how to bring it all back together?

 

[neileg]

tblCommon is certainly not normalised. All those salary and hours fields should be individual records in a related table.

 

[teiben]

Thats why I asked for assistance....so each field becomes a table? what type of relationship would you suggest?

 

[neileg]

No, each field becomes a record in a single table. The structure might be:

tblValues
ValueID, PK autonumber
CommonID, FK link to tblCommon
ValueTypeID, FK link to table listing all the possible values DirectHourlyTemp etc.
Qty Number

By the way, you shouldn't use $ or #, or any other special characters or punctuation (other than the underscore) in your object names.

 

[teiben]

thanks, I forgot about the poor choice in field names...anyone else can you provide me with some assistance?