Static Text Boxes and Combo Boxes

[hobbit2612 via AccessMonster.com]

Hi,

I wonder whether someone may be able to help me with a database problem
that's had me baffled for a good few days now. I must admit it's quite
difficult to explain but I'll try my best.

I have 3 tables:

StaffDetails Skill
Level

Fields are: Field is:
Field is:
StaffID Skill
Level
StaffName

The database is used to record the skill level of staff.

To start of with I think I'm right in my assumption that the staff details
should be on a single form,

The skills are pre populated (14 in total) in the skills table and within a
continuous subform I need to show these as static text boxes. These obviously
need to be linked to the main form as above.

The level is the level the member of staff feels they are at against each
skill. I would like the user to be able to select the level via a combo box
against each skill within the continuous from mentioned above.

The problem is, is that I cannot get them to match up. I have built my main
form without any problem. However my troubles start when I try and link the
subform. I know what information needs to be on the subform but I can't get a
list of the skills without the combo box being unbound, hence when I use it,
it shows the level against all 14 skills. Then when I try to create the
subform using the Level table as the record source I lose the list of skills,
again being unable to match against the staff details.

Can anyone help please.

Many thanks and regards

Chris

 

[KARL DEWEY]

I did not follow your three tables due to word wrapping.
Your tables should be --
People
Skills
People_Skills

Set a one-to-many relationship between People-People_Skills and
Skills-People_Skills. A person can have many skills and any skill can be had
by many people.

Use a form/subform for the People-People_Skills with combo to select skill
for the person. The form/subform Master/Child links set based on people
identifier.

Use a form/subform for the Skills-People_Skills with combo to select people
for the skill. The form/subform Master/Child links set based on people
identifier.

 

[hobbit2612 via AccessMonster.com]

Karl,

Thanks for taking the time to reply.

I had already created the database with your suggestions, but unfortunately I
don't want the skills to be shown in a combo box but rather static text boxes
and this is where I can't work out what to do.

Kind regards

Chris

I did not follow your three tables due to word wrapping.
Your tables should be --
People
Skills
People_Skills

Set a one-to-many relationship between People-People_Skills and
Skills-People_Skills. A person can have many skills and any skill can be had
by many people.

Use a form/subform for the People-People_Skills with combo to select skill
for the person. The form/subform Master/Child links set based on people
identifier.

Use a form/subform for the Skills-People_Skills with combo to select people
for the skill. The form/subform Master/Child links set based on people
identifier.

Hi,

[quoted text clipped - 39 lines]

Chris