access query with related tables

[webcrab]

Hi!
This is what i need to do and i'm not sure it's possible:
I have two tables with a relation (one to many)between them.
one is retrived directly to a drop down list.
I have another drop down list which i want it to retrive the data from the other table according to the user's choise in the first drop downl list.

firse selection on first ddl will cause the second ddl to be filled with the data according to the first selection.
As I said both of the tables have a connection which is based ob a similar field.

How can I do this using the design query? Is it possible( i know i did that on a website in sql server) but i'm not sure it is possible on a reguler program...

THanx..I realy Need a victory here...

 

[KenHigg]

Sounds like you simply need to use the selection in the first combo box as a criteria in the query used for the rowsource of the second combo box.

 

[maxmangion]

is there a particular reason why you are trying to achieve this at query level? If you do this at form level you can easily implement it using cascading combo boxes.