design help needed

Bobbo · Dec 22, 2009

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

Gina Whipp · Dec 22, 2009

Bobbo,

Well, we know what you have but not what you are doing. In order to
determine a table set-up it would help to know what you are trying to track
and why you are importing it to Access.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Steve · Dec 22, 2009

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)