Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ComboListBox
Message
From
29/07/1999 13:33:23
 
 
To
29/07/1999 13:19:27
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00247782
Message ID:
00247798
Views:
26
>I'm new to Visual Foxpro, so be patient. I have a database called "Inventory" that includes several tables, two of them being "Computers" and "Users". I've got a field called "User_ID" in both tables and that is how the two tables are linked. When entering data into the "User_ID" field in the "Computers" table, I want the user to be able to pick from a list of existing records in the "User" table. For the most part I've done this with a ComboListBox. The information is displayed from "User" table correctly and after clicking on the selected record in the "User" table, the value of the "User_ID" in the "Users" table is transferred to the "User_ID" field in the "Computers" table. My problem is: When the record is first pulled up, the current value for the "User_ID" is not displayed in the ComboListBox. I can step through each record in the table and all other fields display correctly and I can browse the table and the data is actually there. I'm sure there is a small detail that
>I've missed, but I can't find it. Can anyone help?
>
>Thanks,
>Van

I'm not exactly sure this is what you're asking, but in the ComboBox .Init() you may have to initialize the control's value e.g.

THIS.Value = Customer.User_ID
DODEFAULT()
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform