Hi,

Using Data environment. Have 2 tables. Main table is purchases. One of the fields of purchases is Department number (foreign key). The other table is Departments with 2 columns. One is DeptID (key) and the other is DeptDesc. As the user enters data (using a form) to add records to the Purchases table, I want DeptDesc to display in a label control after the user enters the DeptID (foreign key) into the Purchases table. Any automatic binding for this? Appreciate any ideas.
Thanks!
John