Reporting Database - Help with Primary Key

S

shane

I'm working on getting my tables normalized and am working on definining a
primary key. Production works a 12hr rotating schedule so we have 4 shifts,
2 days and 2 nights (A, B, C, and D respectively). There are also 4
departments that will be entering information, where 2 of these departments
are broken down into cells of 4 lines each. Line numbers are always
associated with the same cell.

On the reports we want to combine data from each department by date, shift,
and cell.

After reading about normalizing I'm at odds with creating a primary key that
is not a multi-valued field. Any suggestions are greatly appreciated.
 
D

Damon Heron

More info, please. When you use the word cells, are you referring to
fields in your table? How about showing the table structure for us....

Damon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top