i have an dtr and employee table. both have empno but only employee table has the shift field.

say i have first record in dtr, empno=1234, i'd like to be able to get the shift of empno=1234.

in the dataenvironment, i add dtr and employee. both have indexes on empno, so i was able to drag the empno from dtr to empno of employee.

i have say a simple thisform.caption=employee.shift. but why does the shift always returns to the first record of employee?

i tried reversing the relation, like dragging the empno of employee to empno of dtr. but i still don't get the right value for shift.

what is wrong?