Using Reports to Display all Portal Records
I have a Staff Personnel database, which has a portal to display an employee's salary/bonus history. I am trying to create a report that will display each salary year for an individual employee. I am not sure if the problem lies with how the tables are related, or how the report is structured, but after playing around with the report a little, what I have gotten to is that it will display a record from the portal, but doesn't associate it with an employee. Here is how my table relationships work;
Personnel Records Yearly Compensation
xP_EmpID --> xD_EmpID (Serial number to number field)
p_ComSum --> EmpComSum (Serial number to number field)
As far as my report goes, the layout itself is displaying records from Yearly Compensation. It has a subsummary when sorted by Personnel Records::FirstLast (Leading) and a subsummary when sorted by Yearly Compensation::Year (Trailing). Any tips on what I'm doing wrong?