VFP- Combo Box 
Author Message
 VFP- Combo Box

Hi. SOrry for the length of this, but I really need some help. I have a
simple form that has the following data environment.

         Name                            Group
      ----------                     ------------
         Name             ------------> Group_id
         Group_id<<-----/               Description

Each table has two records:

Group:   2, Group2
         1, Group1

Name:    Name1, 1
         Name2, 2

Just a simple case. I have a form with a combobox and a textbox, and
two buttons (next, prior). The combobo has the following properties
changed (from the default).

RowSourceType = 3 - SQL Statement
RowSource     = SELECT description, group_id FROM group INTO CURSOR
                       crGroup
BoundColumn   = 2
ControlSource = name.group_id

Now, like this it works fine. I can traverse the name table and the combo
box displays the correct value. But as soon as i want to order the SELECT
statement like so, SELECT description, group_id FROM group ORDER BY
                          description INTO CURSOR crGroup
the combo box values are wrong as i traverse the name table. Is this
the way combo boxes work? Or am I missing something painfully obvious?
Any help would be greatly appreciated, as I am fairly new to VFP.

  Later,
  Bret Champoux, Systems Analyst
  Treasury Board Secretariat, MoF&CR
  387-9068



Sun, 23 Aug 1998 03:00:00 GMT
 VFP- Combo Box

Quote:
> Is this the way combo boxes work? Or am I missing
> something painfully obvious?

No, you're just another victim of the COMBO BOX FROM HELL!

Stuart Fairful
Bytemark Ltd
Glasgow
+44 (141) 226 4890



Mon, 24 Aug 1998 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. VFP Combo Box

2. Help needed with VFP Combo Box

3. VFP Combo box problem with one-to-many relationship

4. VFP: Combo-boxes with Views Problem

5. VFP combo box

6. VFP - combo box incremental search

7. VFP: Combo Box

8. Populating a combo box from another combo box

9. Populate a combo box from another combo box selection

10. selecting records for 2nd combo box dependant on first combo box

11. VFP 5.0a combo boxes and NT

12. Question on Combo Boxes for VFP 5.0


 
Powered by phpBB® Forum Software