CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013

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

  2. #2
    Join Date
    Jul 2005

    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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

On-Demand Webinars (sponsored)

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.