many to many subform

[Carnafex]

Hey everyone, just hoping someone can answer this problem that I have with a many to many subform. The subform is already set up, but I need to change it over to a way Ill show below, but I dont have any idea how. The list is a list of a persons skills (in a factory), and is many to many because each person can have many skills and skill are shared by many people.

The main form to which the subform is linked has a record for each employee.
Okay, the old way is like this:
(each line is a skill, which is selected through a combo box, and then a text field next to it contains the skill level [A to E]

• SkillOne - D
• SkillTwo - A
• SkillThree - C

This works well, but my employer would like it to be displayed like this: ( the underscores are just used to represent spacing)

• SkillOne - D ______ SkillThree - C
• SkillTwo - A ______ SkillFour - B

and each Skill# is fixed (so for example, one is the skill of Assembly, and will always be assembly, and two is welding etc) and the field next to it is linked to the related skill
Im not too sure how to change this over (as it probably will have to become some sort of field for each skill, and not remain in a sub form) and would like some help doing so. By this I mean like if I use a text field to do this, and then how do I link the field to the related skill and get the skill level next to it to be placed in the correct persons record, etc.

Hopefully this makes sense, and if it doesnt, just ask and Ill post any info you need.

Thanks
Jason

 

[Pat Hartman]

I don't understand your explaination but I suspect that you are being asked to un-normalize the table and are attempting to comply. Resist. You will have a great deal of difficult working with an un-normalized structure. Compromize on the presentation on this form if you have to. You may need to make an unbound form to make the form look the way the user requested.