Hi all ,

I am new here and my question may have been asked before . But I need help and advice .

I would like to know how get my drop down menu information that is pulling from an access database table to populate two fields which are join .

E.g I Have two table one name Model and one name Cat.

In my cat table i have the following fields CATID. MODELID, CAT

And in my model Table I have ModelID Model and CATID .

I want to be able to create a from where once I select a Model the corresponded CATID will automatically selected.

I hope this makes sence and someone out here can help a girl in a little pitfall.

Thanks in Advance

Natalie