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 :
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 ...