Hello i have created two tables a table
tblCountryhaving [ Countryid, Country,]
and a table tblRegion having [RegionID, Region,RegionCountry(Foreign
key) ]
I have Create two combo box one having the Country and the other
having the Region and i have synchronize them.
My Question is I want to have a screen shown only once and the user
choose his country and after that to show only the regions that are
coresponding to that specific country without having the user
selecting each time on a new record the country
For example Select in beginning country Germany(From the list of
countries) and record after record the Germany should be shown in
combo box(maybe) and in the cboRegion the regions of Germany shown
every time without selecting germany all the time when you add new
records
Thanks

P.S i hope you understood what i 've said