You do not have a relation set between the tables? Then in the refresh of the textbox you might do something like:

=SEEK( billingTable.CustNo, 'CustTable', 'byCustNo' )


>I created a combo box in VFP5.0 in a billing form to lookup the the customer. I want their name to appear in a textbox next to the combo box. I got the combo box to display the information I need but the textbox shows a name that is unrelated to the customer number when I navigate through the records. The customer table and the billing table are not directly linked to each other. There are two more tables between them linking them together in the data environment. I thought this would be easy like it is in Access - what am I doing wrong? - thanks, from a rookie programmer in CA.