Results 1 to 2 of 2

Thread: populating a combo box

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Location
    Tylertown Mississippi
    Posts
    4

    Exclamation

    I have a combo box that pulls data from a database table and works fine.
    My table looks like this:

    field1 field2 field3
    37 0.397 0.399 0.402
    37 0.392 0.396 0.408
    37 0.397 0.412 0.403
    37 0.397 0.476 0.403
    38 0.398 0.452 0.403
    38 0.398 0.409 0.403
    38 0.398 0.402 0.404
    38 0.398 0.401 0.404

    The problem is, I only want the combo box to display one instance of "field1". For example, I want 37 to be displayed only once, instead of twice, and 38 once, and so on...

    THANX for any help on this!!!!

  2. #2
    Lively Member
    Join Date
    Aug 2000
    Location
    Australia
    Posts
    82
    Not sure if I get what you are after, but as a suggestion. Re the Combo box that pulls data from a DB, how about populating the Combo box with the result of a SQL call with the DISTINCT predicate??

    For example, "Select DISTINCT [Field] From [ThisTable] where ...."

    Cheers
    Adrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width