Multiple records in single form, but not table view

[Guest]

Hi Everyone

My project is an employee database with multiple EMPLOYEES who each have multiple SKILLS (up to 20 skills
I want to make a popup form when an employee number from another form is clicked. This form will display the EmployeeNumber, EmplName and all his skills. The method I am thinking of is to load a subset (skill recs that match the employee#) into an array and then to the form. Am I explaining clearly

I want it to look like: 99999 Doe, John SKILL1 SKILL2 SKILL3 SKILL4 SKILL5 .....SKILL19 SKILL2
where SKILL(1-20) are stored in one table. In this example, employee 99999 has 4 skills
e.g. 1 99999 SLIN
2 99999 PAYL
3 99999 F
4 99999 W
5 12345 SLIN
6 12345 TRAC

 

[Chris Nebinger]

Check into a Crosstab query. That will change the format
of the data.


Let me know if you need more assistance.

Chris Nebinger

-----Original Message-----
Hi Everyone!

My project is an employee database with multiple

EMPLOYEES who each have multiple SKILLS (up to 20 skills)

I want to make a popup form when an employee number from

another form is clicked. This form will display the
EmployeeNumber, EmplName and all his skills. The method I
am thinking of is to load a subset (skill recs that match
the employee#) into an array and then to the form. Am I
explaining clearly?

I want it to look like: 99999 Doe, John SKILL1

SKILL2 SKILL3 SKILL4 SKILL5 .....SKILL19 SKILL20

where SKILL(1-20) are stored in one table. In this

example, employee 99999 has 4 skills.