Hi,
I have three tables Leave request, Worker, and leave request details.
In the leave request table I have created a lookup - one to many relationship with the worker table. There has seem to be a lookup that the system also created?
I also created a relationship between the leave request table and the leave request details table (one to many). see below:
When I go into view, active leave requests, and click related tables I am able to populate the worker name from the worker table, but I nothing is showing up from the leave request details table when I try to add columns from the leave request details relationship:
Any reason why this could be happening? And how to get around it?
Regards,
Henry