Multiple records in single form, but not table view

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
EMPLOYEES who each have multiple SKILLS (up to 20 skills)
I want to make a popup form when an employee number from
Click to expand...
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
Click to expand...
SKILL2 SKILL3 SKILL4 SKILL5 .....SKILL19 SKILL20
where SKILL(1-20) are stored in one table. In this
Click to expand...
example, employee 99999 has 4 skills.
 
Back
Top