If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

[RESOLVED] Accessing a Table mulitple times

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 #?

Re: Accessing a Table mulitple times

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

JG

... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...