I have one table for vendors, one for customers and one for countries among
others. The two first have a field "countryNo" and the forms have references
to the country table via combo boxes for registering the addresses. It works
as intended for both tables.

In a query I want to get the fields for both the vendors and the customers
addresses together with orders. The addresses are written one by one and
they show up as expected, but when I use the country table to get the
countries I cannot get them properly.

Is there a way to tell the query that with the vendors country number it
should write the vendors country and with the customers country number show
the customers country?

/ Rolf