I have a form called Company and this is linked to a training records form. On the training records form I have set up
Title: Mr, Mrs,etc.
Forename
Surname
I have then created a query (Trained List QuerY) which includes
Company Name
TrainedList: [Company Training Records]![Forename] & " " & [Company Training Records]![Surname]
I have a seperate form called Documents, which has a Combo box for the Company name and a sub form linked to it to display the companies details.
However I am trying to create a sub form or Combo Box which is listed the TrainedList. I can get this to work but regardless of number of people trained per company I can only get one persons name to show.
What do I need to do in order to get this to work. I have tried Group By in the query I have created but when it is run it displays numerous fields with the same company name in and the persons name in the next.
Title: Mr, Mrs,etc.
Forename
Surname
I have then created a query (Trained List QuerY) which includes
Company Name
TrainedList: [Company Training Records]![Forename] & " " & [Company Training Records]![Surname]
I have a seperate form called Documents, which has a Combo box for the Company name and a sub form linked to it to display the companies details.
However I am trying to create a sub form or Combo Box which is listed the TrainedList. I can get this to work but regardless of number of people trained per company I can only get one persons name to show.
What do I need to do in order to get this to work. I have tried Group By in the query I have created but when it is run it displays numerous fields with the same company name in and the persons name in the next.