Input form links

A

Art

Hi There

Can someone please help.I'm trying to develop a database
in ACCESS 97 for my coins . I've set up the tables
concerned. I have a problem with the input form, where I'm
try to link (via drop down)into the relevant data boxes
for example

Country
Dynasty
Dynasty rulling date

What i would like to see on the input form:
If I choose any Country (from the drop down)eg. Great
Britain; then in Dynasty (I would like to see all & only
Kings & Queens (on the drop down) for GB
Once I have chosen one - eg. Queen Victoria (in the
Dynasty Box)I would like to see the correct data
in "Dynasty Rulling Date" box appear as (1837-1901).

I've created a qry which incorporates the above 3 tbls
I just need to be able to link them all correctly. Can
anyone help.

Thx

Art
 
Top