Parent Data Not Showing In Child Record
I've asked this question in many different ways, but I think I'm not clearly explaining my problem, so I'll try again and hopefully it'll work this time.
My Punch card Filemaker solution only has 2 tables: EMPLOYEES and TRANSACTIONS
Records displayed by the LIST/REPORT layout are sorted using the ClockIn_date field
When a new Punch card record (TRANSACTION) is created, it needs to be assigned to an employee (using a value list linked to the _Emp_ID field)
My Relationship graph is a 1-MANY:
I should also point out that the LIST/REPORT layout has 4 parts: a header, body, trailing grand summary and footer parts.
The LIST/REPORT layout has merge fields that are supposed to retrieve related data (name, phone# ...) from the EMPLOYEES table, but this doesn't seem to work because no data is displayed. Those fields are blank although the data exists in the native TABLE.
I'm not sure what I'm doing wrong, any help can help.
Resolved! My employee ID value list was associated to the wrong field.