Forum Discussion
LauraThacker
Qrew Captain
It sounds like your child-Overtime records have not "populated" the related-reference field value that connects them to the parent-Employees table.
Can you run a List All report in your Overtime table and check the [Related Reference] field value is populated correctly. If not, this is your issue. If it is; then look at each of your Lookup fields and make sure that the field is properly setup to view the data from the parent-Employee record from the relationship you have built.
If you still do not see data; double-check that the data you are "looking up" actually exists in the Employees table for the employees where you have Overtime records.
Post a screenshot if you can.
Can you run a List All report in your Overtime table and check the [Related Reference] field value is populated correctly. If not, this is your issue. If it is; then look at each of your Lookup fields and make sure that the field is properly setup to view the data from the parent-Employee record from the relationship you have built.
If you still do not see data; double-check that the data you are "looking up" actually exists in the Employees table for the employees where you have Overtime records.
Post a screenshot if you can.
AndrewLe
5 years agoQrew Trainee
I looked at the child table's [Related Reference] field and found that it indeed doesn't not match the the parent table's [Reference Key] field; which, as you predicted, would explain why the LookUp fields are not populating correctly.
Thank you very much for your advice.
Thank you very much for your advice.