I am new to VFP 6 so forgive the utter frustration. I can't get a simple combo box to work. Using the form wizard, I created a screen based on three tables: wcenters, wctypes, skills. wctypes and skills are lookup tables. Every record in wcenters MUST have a wctype. May or may not have a skill. I created a screen with other fields from wcenters and two dropdown list boxes one for the types and one for the skills. There are records in the tables. When the form runs the values for types and skills are NOT showing in the list boxes. The lists boxes are populated with the correct field values, but when I start the form or move through the records they are all empty. I want them to show the value assigned in wcenters. (I do NOT want the user to create new types or skills from within this screen.)
ControlSource: wcenters.wctype
RowSource: wctype.wctype,wctdesc
RowSourceType: 6 fields
BoundTo: .f.
(I tried it with BoundTo=.t. and they still didn't work.)
So, how do I get these guys to work?