combo box listing based on a combo box listing

[allstar45]

What I have is two tables, let's call them tableA and tableB. tableB is a child of tableA.



What I want is 2 combo boxes. first one is a list of the members in tableA.

The second combo has to be a list of all the members of the selected member of tableA in tableB.

Incase that didn't make sense, here's what the user will do:

Select a book (tableA) from combo1 then when they go to select a chapter (tableB) in combo2 it only contains the chapters in the selected book.

Thanks in Advance!

[pbaldy]

Like this?

Baldy-Cascading Combos

[ssanfu]

This is called "cascading combo boxes" (also works with list boxes). Google "cascading combo boxes"

Links:
http://datapigtechnologies.com/flash...combobox2.html

RogersAccessLibrary.com

[allstar45]

Thanks both of you!

<3