motscotland
Registered User.
- Local time
- Today, 22:22
- Joined
- Oct 29, 2003
- Messages
- 19
HELP!! Can't get multiple records to display
Hi all,
I am a relative newbie to Access development and have hit a problem I canot seem to solve!!
I have a main employees table, a qualifications table and a qual code table. They are all linked appropriately BUT I cannot find a way to display each employee along with ALL their qualifications (up to 8 per employee)!! They show fine as a list (continuous) or one after another (single form).
How can I display these as follows?
Employee Qualification
J Smith Degree
Diploma
First Aid
Is there anything I should bear in mind at the data entry stage as well - ie how to get the entry form to pass new qualifications (up to 8) to the qualifications table? The data I have is existing data which was imported to the present tables.
Thanks in advance for your help.
MoT
Hi all,
I am a relative newbie to Access development and have hit a problem I canot seem to solve!!
I have a main employees table, a qualifications table and a qual code table. They are all linked appropriately BUT I cannot find a way to display each employee along with ALL their qualifications (up to 8 per employee)!! They show fine as a list (continuous) or one after another (single form).
How can I display these as follows?
Employee Qualification
J Smith Degree
Diploma
First Aid
Is there anything I should bear in mind at the data entry stage as well - ie how to get the entry form to pass new qualifications (up to 8) to the qualifications table? The data I have is existing data which was imported to the present tables.
Thanks in advance for your help.
MoT
Last edited: