Subform Link?

[turtle]

I am creating a database that tracks the Techinical Skills of our
engineers. There are about about 200 techinical skills that they will
need to fill out by giving themselves a ranking. Some fields they
will not fill out and others they will. Here is an example:

Employee # 1

Languages Skill Experience (yrs)
C++ 3 4
VB 2 2
Java
BASIC 5 10

Neworking Skill Experience
Bridges 1 1
Hubs
LAN 4 5

Here is my question...
I figured I would make a form with general info and a subform with the
different major categories (languages, networking, Databases). How do
I link the form/subform. If i link on employee name it will only show
fields that already have the employee name therefore the subform will
show no records.

[turtle]

Allen,

I really don't like that approach either. Is there any other way. I
believe in one of your first post you said I would need a record for
each skill for each employee... if this is true, how do I do that
without creating a record for each skill everytime a new employee
starts?
thanks
Keith

[Allen Browne]

Rather than create a record for every possible combination of employee and
skill, what I originally suggested was that the link table would contain a
record for each actual combinationof employee and skill. That is, if an
employee has 12 skills, they appear in 12 rows of the link table. It would
be a very unusual workplace if all employees had all 200 skills.

To create the records for the 12 skills is as easy as picking a skill on 12
rows of the subform. There is no way the program can do this
programmaticall y, since it cannot know which skills an employee has.

If appropriate, you could add a Yes/No field to the Skills table to indicate
if this skill is considered to be a default. You could then use the
Form_AfterInser t event to only add the skills " ... WHERE (IsDefault = True)
....".

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"turtle" <ko****@vistaco ntrols.com> wrote in message
news:58******** *************** ***@posting.goo gle.com...

Allen,

I really don't like that approach either. Is there any other way. I
believe in one of your first post you said I would need a record for
each skill for each employee... if this is true, how do I do that
without creating a record for each skill everytime a new employee
starts?
thanks
Keith

[turtle]

thanks again guys...
I think I am going to go ahead and just add all the skills for all the
employees in the tblemployeeskil l table. Basically my boss likes how
it looks with all the skills showing up for each employee in the
subform... I have it set that if he double clicks the subform skill it
will run a report showing anyone else with that skill. Thank you for
taking the time to answer my questions. I think I only have one more
but I can probably figure it out by using Allen's append query code.
If I add a new skill I will need to make sure that skill gets
incorporated for every employee. I think i will just need to write
another append query.
Once again, thank you guys so much for your time.

Keith