Forms Sub-Forms HELP PLEASE

[jenny23]

Hi friends, I really like this forum. I found right answers each time I posted.
Thanks for all your help so far. I appreciated that.
I have another question:
I created a table like this:
TableA
id student class
-- ------- ----
1 john his
2 ray eco
3 lisa his

TableB
Class Stu_id Name
--- ----- ------
his 1 john
his 1 lisa
eco 2 ray

I create a form from TableA and a subform from TableB, . Actually, I create a dropdown list for class field from TableA, and a subform for all fields from tableB, ...
Each time i click on his from the dropdown list, I'll see 2 records show from the subform.
Can you please show me how to do this?
Thanks.
Jenny.

 

[Pat Hartman]

I don't know what you're trying to do. The two tables seem to have the same three columns, just in a different order.