Multiple listings (1 Viewer)

S

SusiJane

Guest
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

Registered User.
Local time
Today, 07:42
Joined
Oct 23, 1999
Messages
13
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
 
S

SusiJane

Guest
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.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom