Hi all,

I've a technical question about a query with joins  : After inserting a new record, I don't know how to refresh all the columns coming from the joins. CachedUpdates is on and the changes are just posted...

For example, if you have a query like :

      SELECT *

      FROM EMPLOYEE

      LEFT JOIN DEPARTMENT ON DEPARTMENT.DEPT_NO = EMPLOYEE.DEPT_NO

      LEFT JOIN JOB ON JOB.JOB_CODE = EMPLOYEE.JOB_CODE

                   AND JOB.JOB_GRADE = EMPLOYEE.JOB_GRADE

                   AND JOB.JOB_COUNTRY = EMPLOYEE.JOB_COUNTRY

      ORDER BY EMP_NO

and a DBGrid to show and edit the data.

When you insert a new employee, the columns EMPLOYEE are updated but not the columns from the DEPARTMENT and the JOB tables...

The "refresh" doesn't work ...

Best regards,

Laurent.