I have a tables A & B say,

Table A
CusNo CustName
00001 Paul McCartney
00002 Ringo Starr

Table B
CusNo Orders
00001 Bag
00001 Shirt
00002 Shoes
00003 Bag
00004 Shirt
00004 Shoes
00004 Bag

In my form, I made use of the DE, and drag Table A's custNo to Table B's custNo. I want to add a combo box in my form to display all orders when a particular custNo is selected.

What do I need to change in my combobox's property? For the controlsource, I changed it to b.orders.

BUT, it doesn't work.

Can you help me?