In my table &#039;sites&#039;, one field is country, which has values as numbers which relate to a table called &#039;countrys&#039;<BR>for each site that is listed i want to pull up the country name from the table &#039;countrys&#039; using the value in the field &#039;country&#039; using the countrycode rssites("country").<BR>The only way i can think to do this is to query a recordset for each site. But if i am listing 100 sites on a page this is too many recordsets ?<BR>What is a way to do this ?<BR><BR><BR>Thanks <BR>