F
FARAZ QURESHI
Hi!
Quite new to the treasure of Access 2007 sure am interested in and shall
appreciate expertise of you guys in the following matter:
1. Table "Location" consists of fields
(a) Country
(b) City
(c) Zip Code
2. Table "Customers" consists of the lookup field of Zip Code
3. Now I want to create a form of Customers where I also want to include the
three Location fields.
How to:
1. Insert combo box for Countries to be shown once/distinct?
2. If one country is selected only related cities to be reflected in the
City ComboBox?
3. If directly a Zip Code is inserted Country & City fields to be
automatically looked and filled up?
Your reply shall be highly appreciated specially if a link to a sample file
or tutorial/relevant article is provided.
Thanx in advance for your precious time!
Quite new to the treasure of Access 2007 sure am interested in and shall
appreciate expertise of you guys in the following matter:
1. Table "Location" consists of fields
(a) Country
(b) City
(c) Zip Code
2. Table "Customers" consists of the lookup field of Zip Code
3. Now I want to create a form of Customers where I also want to include the
three Location fields.
How to:
1. Insert combo box for Countries to be shown once/distinct?
2. If one country is selected only related cities to be reflected in the
City ComboBox?
3. If directly a Zip Code is inserted Country & City fields to be
automatically looked and filled up?
Your reply shall be highly appreciated specially if a link to a sample file
or tutorial/relevant article is provided.
Thanx in advance for your precious time!