View Single Post
  #2 (permalink)  
Old May 22nd, 2005, 06:16 PM
peace95 peace95 is offline
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts

Martin, I am very new to this forum, but my suggestions are:
  1) look at the database structures, the primary and foreign keys and their relationships (1-to-many, or many-to-many) of the two tables you are linking or using in your drop-down list. From what u listed, it seems that the Product has multiple single sales (Product Line);
   2) try using the word "DISTINCT" in the select statement to obtain a single occurance of the Product Line, create a new table, New_Product_Line_Tbl. Then Display in the drop-down List, the Product and the New_Product_Line_Tbl, using the LEFT JOIN;
   3) look at #1 and #2 outside of the drop-down-list, to see what is actually going on at this point.

Hope this helps, hard to say with out looking at the structure of your tables.

Good Luck

Reply With Quote