countinuous form problem

[alap43841]

I have two tables where in one table I store the personal detail of employees like per no, name, address etc and another table where I store the training detail of employees like per no and training he has under gone. One employee may have more than one training information. I want to create a continuous from where I want to view the list of my employee with the personal detail including the training he has attended. can I create a query and view it in a continuous form. Please help. Thanks

 

[Luddite Lad]

Yes you should be able to create a query to collect all the data that applies to any one employee.

The way to display this would be to have a single main form, on which you display the employee details, and then have a continuous subform to dispaly all the courses the employee has completed.

Have a look at the attached DB

 

[Vassago]

Double posting is not tolerated here. You should pm a mod and have them merge the threads or delete any duplicates.

 

[Luddite Lad]

Double posting is not tolerated here. You should pm a mod and have them merge the threads or delete any duplicates.

I trust I've not wasted my time then

 

[alap43841]

No, it is not a duplicate post though the content is same. I want create a form based on query. The query gets data from two tables one is employee per info and other is employee training info. I want to make list of my employee which should have employee's personal info with the training he has completed. I can make form that is suggested by "Luddite Lad", but I want to make a list with all informations. Please see the attachment. Thanks.

 

[Luddite Lad]

Sorry I misunderstood what you were trying to achieve in your initial post. I'll have a think about it, perhaps one of the more knowledgeable contributors in this forum may have some ideas.

 

[alap43841]

Thanks, I appreciate your response. If it is a clumsy job to create a form like this, is it possible to create a report like that? regards

 

[WayneRyan]

Alap,

http://www.access-programmers.co.uk/forums/showthread.php?t=146355&highlight=wayne+parent+child

hth,
Wayne

 

[alap43841]

Thanks WayneRyan, let me try.