table correct

[teiben]

I need to create a db from a very large excel spreadsheet (currently 180 rows, and 2 columns for each day of the week)
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? (Ignore the use of # in the field types)

 

[Guus2005]

It depends what you want to do. If you want a normalised database you might read up on the Normalisation process (Wikipedia). I see a lot of reoccuring fields so it is my believe that the tables aren't normalised.

You should ask yourself: "Is it possible that one ManufID can have more than one AbsentHours or Date or Plant or ... ?"

If so, you should have a one to many relationship. If not, consider joining the tables.