General information
Category:
Coding, syntax & commands
Title:
Setting relation in dataenvironment
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?
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