Use of ID as pivot

[pokecell]

I work on an enterprise which we send people to do field work, & i am doing a database in Access 2013, there i have a table with all the data of our employees defined by an ID, & i have also a table with all the drivers that take em defined by another ID for them, the problem is when i am trying to make a query...
I made a table with the ID of the drivers, the ID of our employees that are on that trip with him, the departure date & the arrival date; and when i try to make my query i want it to display: the both dates, & Name of the driver, his ID, & the truck he is using (all this info is on the driver table), and also to diplay the name, the ID & the rank of the employees going with him (all this info is on the employee table), the problem comes that since i am using the ID to search for every employee info, when i put that more than 1 employee is going in that trip i get this error on the top of table: Expr1000, Expr1001; instead of ID, Name, etc... & no data is displayed.
I hope you can help me Thank you a lot

[rzw0wr]

Please read the following.

http://www.excelguru.ca/content.php?...-cross-posters

Dale

[pokecell]

xD well i havent seen anything like my problem around neither in english or spanish , all the tutorials, & forums explain the same many to one many to many, but the problem of mine is that i want to use an ID in a table to extract several info from that row, & also use the ID with a different number to extract the same info of another employee, is that not possible? cause i havent seen anything a like around xD