Here's the setup...
Table - General Contractor (tblGeneralContractor)
Primary key - ID
Company Name- txt
First Name-txt
Last name-txt
Address-txt
City-txt Use a look up colum directed under tblOregonCity.City so there is no misspellings of citys when inputed, This is a drop down menu.
County-txt Use a look up colum directed under tblOregonCounty.County so there is no misspellings of Counties when inputed.This is a drop down menu
State-txt
Zip Code - number
Table - Oregon Cities (tblOregonCities)
(Primary key) City - Txt
County - txt Use a look up colum directed under tblOregonCounty.County so there is no misspellings of citys when inputed.
Table - Oregon County (tblOregonCounty)
(Primary Key) COunty - Each county has a unique line in each database.
So, What I want to do is on tblGeneralContractors, select "CITY" from the drop down menu, and have "County" update from the referenced county on tblOregonCities.
I tryed useing querys, I got it to work ON a query, but when I added it to the row source on tblGeneralContractor.County, it was blank when I select the city from the Table.
What do I do?
Table - General Contractor (tblGeneralContractor)
Primary key - ID
Company Name- txt
First Name-txt
Last name-txt
Address-txt
City-txt Use a look up colum directed under tblOregonCity.City so there is no misspellings of citys when inputed, This is a drop down menu.
County-txt Use a look up colum directed under tblOregonCounty.County so there is no misspellings of Counties when inputed.This is a drop down menu
State-txt
Zip Code - number
Table - Oregon Cities (tblOregonCities)
(Primary key) City - Txt
County - txt Use a look up colum directed under tblOregonCounty.County so there is no misspellings of citys when inputed.
Table - Oregon County (tblOregonCounty)
(Primary Key) COunty - Each county has a unique line in each database.
So, What I want to do is on tblGeneralContractors, select "CITY" from the drop down menu, and have "County" update from the referenced county on tblOregonCities.
I tryed useing querys, I got it to work ON a query, but when I added it to the row source on tblGeneralContractor.County, it was blank when I select the city from the Table.
What do I do?