design help needed

  • Thread starter Thread starter Bobbo
  • Start date Start date
B

Bobbo

Need some guidance on a task I am looking in to. I hava an excel spreadsheet
that exports some data in to a access db table. There are 6 fields in the
table (ID, MName, Role, Proj, Joined and Group. What I am trying to figure
out is a way to clean up the table. In each field there are duplicates. I was
thinking that I could create a separate table for the MNames and Proj fields.
Then replacing the data with the key id from the new fields.

Does this sound like I'm going in the right direction.

Thanks
Bob
 
Hi Bob,

Without knowing what exactly is the data in the fields, it seems you need
separate tables for Role, and Group also. Then you need a junction table
that records each MName on each project. The junction table would look like:
TblProjectMName
TblProjMNameID
ProjectID
MNameID

Steve
(e-mail address removed)
 
Back
Top