I have a table where each record has three different employee Id #'s, I need to get them employee name from the employee table. Can I do this by connecting to the employee table once? or do I have to select/connect to the employee table three different time, with the key being each different employee id #?
Add Employee table 3 times to the rpt
To the second and third table set an Alias
Link the first employee Id to the first table
Link the second employee Id to the second table
Link the third employee Id to the third table
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...