Multiple listings (1 Viewer)

[SusiJane]

Using 4 tables of information in a single database to create a report. Major info I’m working with is employees, specific locations, and aircraft. I want to create a listing of locations showing employees and aircraft at each one. Instead of merging the information and listing all employees at one location, it lists the location as many times as there are employees, and again with as many times as there are aircraft. What have I missed? Or is this expecting too much? Perhaps I set up my original tables incorrectly. I would appreciate any ideas.

 

[peldridg]

I presume you are using a query to join the tables. Your joins need refining. Its difficult to recommend what to do without seeing the table and the foreign keys

Hope this helps
Phil

 

[SusiJane]

Yes, I'm using query with joins between tables, then attempting to run reports. Can you explain more on "Your joins need refining"? I wasn't able to find good info in my resources.