Duplicate/Multiple Fields in a Table (Recordset?)

wordsmith

Registered User.
Local time
Today, 21:14
Joined
Jan 30, 2006
Messages
33
Hi All,

A bit new to this, any help most appreciated.

I'm trying to set up a table which will have multiple fields (a recordset? is that right, if so I don't know how to set one up in access). Its for a skill set which is utilised by specific lines in a production plant.

Each line in the plant has a set of skills required. I have a skills table (SkillID and Skill), what I want to do is have a Skillset which I can then link to each line

So for example Skillset 1 with a SkillsetID will also have in that table skill 1, skill 2, skill 3, but all taken from the Skill table. However that would involve having the SkillID field numerous times in the same table, but this cannot be done?

The idea is that for each line I can link the Line table to the Skillset table and that tells you what skills are needed for that line.

I hope this makes sense.

Thanks all.
 
i think something along these lines (but am ready to hear feedback...)

Code:
tblSkillSet	tblSkillSetSkills	tblSkill
-----------	-----------------	--------
SkillSetID	SkillSetID		SkillID
SkillSetDesc	SkillID			SkillDesc
 
Looks good to me, cheers Wazz!
 

Users who are viewing this thread

Back
Top Bottom