Different fields related to the same field

[setis]

Hi all,

How can I make the attached query to work?

As you can see I have 3 country fields related to the country table.

How can I get the country name for every field on the results?

 

[isladogs]

Your post is a masterclass in not giving a clear request!

1. Country table? Do you mean tblCountries?

2. Which 3 fields are you trying to extract & from which tables?

3. Your screenshot doesn't show the name of the table on the left.
Please repost showing all the table or better still post your db

 

[setis]

Your post is a masterclass in not giving a clear request!

1. Country table? Do you mean tblCountries?

2. Which 3 fields are you trying to extract & from which tables?

3. Your screenshot doesn't show the name of the table on the left.
Please repost showing all the table or better still post your db

Sorry about that.

* My main table has 2 country fields related to tblCountries
* The ProviderDatabase tbl has 1.

If I run the query without the tblCountries I get the PKs in the results.

I am having issues when more than 1 field is related to the same table like in this case and I would like to be able to get the results on the query for "CountryTo", "CountryFrom" and from the ProviderDatabase, "Country"

Thanks in advance

 

[pbaldy]

You add the country table twice, and relate each field to a different instance of it.