Cascading Combo Boxes

[Access_help_rob]

Hey, my problem is on a form i need to enter purchase notes against lines on an order so i need to be able to select the order and then the stock code so i can enter notes against it.
At the moment i have on combo box from one table which shows order number and stock code, but when u selet a stock code which is in the table more than once it selects the first order number in the table it is connected to rather than the order i want, please ca you help me with this problem, maybe a different table structure etc? please dont tell me to search ive searched for the past hour and tried but i really cant seem to get anywhere thanks
rob

 

[Mile-O]

Can you detail it a bit further?

If you are wanting to cascade this you are going to need your stock codes in one table and your Orders in another.

 

[Access_help_rob]

hey, im not sure how to do cascading at all but wot would be nice is if i select an order, that it would display all the stock codes in that order ? please advise me how to do this
thanks mile
rob