>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