Linking between tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 2 tables that i want to link. One holds a list of countries and the
other holds the holiday destinations so for each trip if someone goes to 5
countries the field displays - US,UK,AU,IT - i need to link these to the
actual names of the countires is there any way i can do this. the minimum
countries is 1 and there is no maxmium so the field could read,
x,x1,x2,x3,x4,x5 so on - the comma is common to all fields
 
How would you expect to display all country names? Would you like a comma
delimited list or other?

You can create a query of all the country names by using both tables with no
join. Set the criteria under the destinations field to:
Like "*" & [tblCountries].[Abbrev] & "*"
 
Back
Top