I need to link 2 table to list the available rows from a Table
after having selected the common code from another Table.

Eg: 2 Tables

Table1: Books Category Table2: Books

Category CatName BookCode Category BookName
-------- ------- -------- -------- --------
111 Friction A001 111 Title1
222 Non-Friction A005 111 Title2
333 Horror A008 222 Title3

Need need 2 DataCombo boxes, one for user to select a Category
Code from Table1:Books Category. Another DataCombo box will then
filter/list only the Books that are related to the Category
selected previously.

However, the listing for the 2 DataCombo boxes will be the
CatName and BookName instead of the Category and BookCode
respectively. Any sample code how how to go about? Thanks.