I have upgraded from 2000 to 2007. My reports are fine until I look at them in design view. Once I open the report, I seem to lose my relationships in the report query.
this is my table structure:
Jobs (contains)
Program Manager
Designer
Leader
Builder
Employee
Name
In jobs, I have a relationship to choose any employee for each position.
In my report query I have the following tables:
Jobs
Employees(alias Program Manager)
Employees (alias Designer)
Employees (alias Leader)
Employees (alias Builder)
The employee ID in each Jobs table position is related to the employee id in the employee table(s).
Report works fine until I open and close it in design view. What happens is that ALL positions default or revert to whichever employee position is listed first in the query. My report shows the same person for all positions.
I have recreated this relationship in my report query several times with no luck. I had to completly recreate this report to get the results that I wanted. The problem now is that I have MANY reports set up this way and do not want to recreate all of them.