Form not displaying data

[Howard2002]

I am in VFP7 and created a form with ssn as my input field and my key field. Set the (name) field control source to mastet_table.name. Have another field (agency) that is from table second_table that has the key field of ssn. The control source in the agency field is second_table.agency.
How do i get the form to display them when you select the 'find' button after entering the ssn?

 

[ramani]

HI Howard,
1. If the ssn field names are same and if you are using the Data environment to open the tables, then, simply drag the SSN field from "mastet_table" into the index area of second_table. And that is done !

Otherwise and another way is
2. In the forms Init event, add the code...

SELECT mastet_table
SET RELATION TO ssnField INTO second_table
LOCATE

This will take care of your requirements.
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com