I hv 2 table in MS Access. the ?

Question

I hv 2 table in MS Access. the

1st table is Country_master which contain

1. country_id numeric (primary key)

2. country_name character

2nd table is state_master which contain

1. state_id numeric (primary key)

2. state_name character

3. country_id as a referential_key to country_master

now I want . I want to make 2 combo box like this

1. please select the country

2. please select the state

when I select contry as a india then only the name of india’s state must display in 2nd combo box

when I select contry as a afrika then only the name of afrika’s state must display in 2nd combo box

Answer 1

Use java-script/AJAX

http://javascript.internet.com/forms/sel...

best:

http://www.quirksmode.org/js/options.htm...

Answer 2

This is pretty easy to do, but a little complex to explain right here.  Here's the link to an article explaining this in the Microsoft Knowledge base.

http://support.microsoft.com/kb/209595/e...

They have other articles on how to do it using different versions of MS Access.

http://support.microsoft.com/search/defa...

Also, Check and see if the sample DB "NORTHWIND" is still available for download.  It has walkthroughs built in explaning how to do a lot of stuff just like this and other really good tricks...

Hope this helps!

Answer 3

I think you need to write a code either with VBA or with other language.