I have a situation that makes me think I am misunderstanding hwo to use teh dependent dropdown listbox feature.
I have three tables (actually more.. but for this discussion I will try and only give relevant info)
Table A has these fields
Usage_ID: {unique, key field}
Product_ID
Date
Table B has these fields
Product_ID {unique, key field}
Manufacture_ID
Product_Name
Product_Price
Product_Details
Table C
Manufacture_ID {unique, key field}
Manufacture_Rating
Manufacture_Info
In a form Table A is the main table. I am trying to have a drop downdown that first lists the manufacture and once that is selected, lists product names from the manufature. The product_id is them what is stored in that field.
When I setup my loop up wizard like this:
Table: Table A
Link Field: Product ID
Display Field: Product Name
Order By:
check the box
Category Control: Manufacture_ID
Category Field: Manufacture_ID
and do teh "test it" button. It seems to work fien and shows me proper info.
Manufature drop list box on top, next bos is product names only for that manufacturer, and teh selected value matches the product ID of the selected product.
Yet, when published, it shows nothing in the dropdown.
Any ideas?
