>Yes thanks, but how should I do it if I can only use a textbox?
>
>I was thinking that since I dragged the orgfile.orgcode into the employee.orgcode, it will automatically point to the correct orgname as I moved my records in the employee table.
>
>How to achieve this?
There are many ways to achieve it. Frankly, I didn't use SET RELATION (one that you use by setting it in Form.Dataenvironment) for millenium. I would just calculate textbox.value, i.e. SEEK in lookup table when next record should be shown and retrieve Orgname.
Edward Pikman
Independent Consultant