Parent Data Not Showing In Child Record

[Treigh]

Hey guys,

I have a very simple solution made of 3 main tables: EMPLOYEES, PUNCHCARD and PAYMENTS.

The PUCHCARD table keeps track of employees worked hours and the PAYMENTS one is responsible for recording payments owed or made to a given an employee based on worked hours.

I have a one->many relationship between the EMPLOYEES table and the PUNCHCARD table

and a one->many relation between the PUNCHCARD table and the PAYMENTS table.

When I assign a punchcard record to an employee ID, I wanna be able to retrieve some of that employee's related data (name, phone, ...) from the EMPLOYEES table and display it in a report sheet that reads from the PUNCHCARD table.

As it stands currently, those related fields do not display anything when the call is made.

I hope I'm making some sense

Thanks a lot

Edited June 28, 2010 by Guest

[Søren Dyhr]

When I see a grand-parenting relational structure, my eyebrows immediately makes some slight gestures, my take here is that punchcard and payment should be in the very same table, and the table should be renamed to something more saying ... "transactions", despite each "punch" might have a different price tag attached.

The reason for this is due to the atomically nature each "punch" should be if you addresses this strictly. Paying something to employer is just a counter posting relieving the balance to settle.

--sd

[Treigh]

Hey Søren Dyhr,

I now only have 2 tables EMPLOYEES and TRANSACTIONS with a 1-MANY relationship.

The EMPLOYEES table being the one and the transctons table, the many.

When I'm using merge fields on the TRANSACTIONS table to retrieve related data from the EMPLOYEES, , the data is not displayed.

I should point out that the report layout is in fact a LIST layout with a header, body, trailing grand summary and footer parts. I'm trying to specify a sorting filed clockin day) and I'll see what it does

What Am I doing wrong?

Edited June 26, 2010 by Guest

[efen]

I don't know what you're doing wrong but does the attached help?

emp_trans.zip

[Treigh]

It kinda did, but I believe I'm not explaining the problem properly.

An image will easily do the trick

Please visit these two pages for a 2 previews.

1 of the graph and another of the REPORT Layout

http://yfrog.com/7efmgraphj

http://yfrog.com/jbfmweeklyreportj

[Lee Smith]

Why didn't you just attach the screen shots here?

Lee

[Treigh]

Sorry, sure here they are

[LaRetta]

It looks like your layout is based upon Punchcard. But there is no relationship between Punchcard and Employees. If the layout is named Punchcard but is based upon Transactions, it should display employee information when placed on the Transactions layout.

I have asked in other forum for verification that both tables have a value in EmployeeID field and that you indeed have a record in each table with that exact value (check to make sure neither has a space or carriage return as well). And make sure both versions of EmployeeID are same data type. The relationship should work and if proper, you can place your Employee fields directly onto this report.

You also should check, if all of the above is correct and your report display is based upon Transactions, that you are using the correct Employee relationship, ie, Employees and not Employees_Prefs. It would have helped to see the report in layout mode so we can see the table occurrence names and field names and parts to your report. If it still cannot be resolved (you can zip and attach an empty clone). :wink2:

[Treigh]

Resolved! My value list (Employee ID) was associated to the wrong field.