multiple table query 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

 

[Vassago]

I've done something like this where I created a combo box on the form header where a user selected a person's name and the detail part of the continuous form showed all training they took. Is this what you are looking for? You'd just have to set the source for the form to a query that looks at the value of the combo box and have the form requery when the value is changed.

 

[alap43841]

Thanks for the quick reply. In fact I am trying to use the query as source for form. I don't think it is possible to generate such query. Thanks any way.

 

[MagicMan]

Im not sure if this will fit your needs, but read up on the Union Query, with option all to create a set of records to display on the continuous form.
Bob

 

[khawar]

You can use a sub form on the main employee form to display main information as well as training record for that employee