Hi all,
I have a problem with a project i am carrying out.
I have a table A. with a X record which is linked to a field Y in table B and field Z in table C.
After I have a table D. This records are linked to a field in table A.
So , records in table D , are linked indirectly to table B and C.
Now i have a table E, which is an input record to control hours.
When I add a record with a field linked to table D, I can add a field with a lookup function, to show the linked field in table A.
My problem is that i need to fill automatically as well, fields Y and Z which are linked to field in table A.
Some idea how to perform this task?
Many thanks in advance
