Insert Problem for Lookup Title

[egnew]

I have the following SQL:

select emp.deptno,emp.empname,dept.deptname
from emp,dept
where emp.deptno = dept.deptno

When inserting a record onto a form, I want the dept.deptname to display as soon as the user exits the deptno field on the screen.

With some databases this is automatic, with DOA I have to use a query.
How do I do this with ODAC?

Thanks

[Plash]

You should set the RefreshOptions of the TOraQuery component to [roAfterInsert, roAfterUpdate]. You should also set the FullRefresh option of the TOraQuery component to True.