I have two list boxes, where the selection of an option from the first determines the options that are displayed on the second. The example I was given uses a filter table, but I’m trying to simplify and not use one. Each list box references it own table to populate its options. The SQL statement used in the second list box Data tab that is used to populate it is the following which doesn’t work. What am I doing wrong?
“SELECT “Ex_subcat_options”, “Ex_subcat_key” FROM “Ex_Subcat_Options_Table” WHERE “Ex_subcat_ID” = (SELECT “Ex_opt_key” FROM “Ex_Cat_Options_Table”)
The first (Ex_Cat_Options_Table) table has the following fields:
• EX_opt_key (the primary key)
• Ex-categories (an alpha-numeric field)
The second (Ex_Subcat_Options_Table) table has the following fields::
• Ex_subcat_key (integer)
• Ex_subcat_options (alpha)
• Ex_subcat_ID (integer)