Finding the Zones in the Access Tables

[Simon TL]

I presume that the Countries table must link to a Zones table. I have looked through all of them without find any likely suspects. Anyone else found them?

I want to do a report of Zones/Countries so we can check that we have it correct. Dead easy if I can find the right table!

Thanks.

[bentleybloke]

Are you looking in the correct access database?

Site folder\Ship Control\SimpleShipping.mdb

[Simon TL]

Hi

and thanks. Yup I need to link to Countries in ActinicCatalog.mdb, and then Zones and ZoneMembers in SimpleShipping.mdb. The key names are bit off (nCountryId and RegionId) but:

SELECT Countries.sCountryName, Zones.ZoneName
FROM Countries RIGHT JOIN (ZoneMembers LEFT JOIN Zones ON ZoneMembers.ZoneID = Zones.ZoneID) ON Countries.nCountryID = ZoneMembers.RegionID;

does the trick. Many thanks.