Combo Box help

[KenshiroUK]

Hi all, I currently have a dropdown menu with a list of products called ProductName that is updated with a price etc. That works fine, however When I come to create another combo box with ProductTitle, I cannot quite seem to get it to update the ProductName combo box. Basically a customer orders Product I want to filter on either ProductName or ProductTitle.

In my ProductName Combo box I have a query

SELECT DISTINCTROW Products.* FROM Products ORDER BY Products.ProductName;

However if I create a second combo box and add this SELECT DISTINCTROW Products.* FROM Products ORDER BY Products.ProductTitle; it will not work.

 

[pr2-eugin]

Instead of using selecting all fields (*) use the specific field name..

SELECT DISTINCT Products.ProductTitle FROM Products ORDER BY Products.ProductTitle;

 

[KenshiroUK]

Instead of using selecting all fields (*) use the specific field name..

SELECT DISTINCT Products.ProductTitle FROM Products ORDER BY Products.ProductTitle;

Worked like a charm!