Many (City) to Many (Zip Code) help
John,
Is this a single expression for the Row Source of a single combo box in
tblCitiesAndZips?
Dan
"John W. Vinson" wrote:
SELECT tblCities.City, tblZipcodes.Zipcode
FROM (tblCities INNER JOIN tblCitiesAndZips
ON tblCities.ID = tblCitiesAndZips.CityID)
INNER JOIN tblZipcodes
ON tblZipcodes.ID = tblCitiesAndZips.ZipcodeID;
|