General information
Category:
Coding, syntax & commands
Title:
DataCombo conrol to list from 2 Tables
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only