Help with query please

[Renate]

Hi all,

Is there maybe somebody who can help me with this (probably not so
difficult) question?
I have an Access database with a table with registrations. In this
registration table there are two fields which represents two different
persons (an id) per record.

In the database there is also a query which lists a full selection of
an external text file. This table has the additional info on persons.

I want to create a new query with the names of both persons in the
registration table. Therfor I need to link both id's to the query with
the persons data. But I don't seem to get it right.
Can somebody help me here please?

Table 1 - Registration
Key
Person 1 ID
Person 2 ID
Other fields

Query 1 - Data on persons (linked text file)
Person ID
Name
Address
Etc

TIA,
Renate

 

[Ragnar Midtskogen]

Hi Renate,

I have never run into exactly this situation, but I think this should work:
Create a new query, select design view and add the registration table.
Then add the persons table twice, the second one as an 'alias'.
Then link one of the persons tables with ID1 and the second one with ID2

Ragnar

 

[Renate]

Hi Ragnar,

THANKS!!! That worked like a charm!
You saved me a night sleep!

All the best,
Renate