The email is a visitor registration confirmation for a website using eCart. I need to use a separate table for the countries to enable different zones for DHL shipping. So the two tables in use are the visitors table and the countries table. The countryID is a key column in the visitors table coming from the registration form which I need to link to it's country name value in the countries table.
Do I add a recordset while in the DW edit page in UE for the countries table and filter by the CountryID
Do I add a recordset that inner joins the visitors and countries table somewhere else?