General information
Category:
Forms & Form designer
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only