Generate a Report from Multiple Tables

[Guest]

How can I generate a report pulling variable fields from multiple tables?
Currently, I have a main table, Employee_Profile that is linked by an
Employee_Key field to other tables. When a query is built from two tables
the query returns blank results. We do have data input in all forms. Is
this a relationship issue within the tables?

Thanks.

 

[Tom Ellison]

Dear Nash:

Hard to tell what you mean. You use terminology not familiar.

What kind of fields (columns? controls?) are variable fields?

"linked"? Do you mean related? Have you designed relationships? Are they
enforced?

"blank results"? Many rows with all columns empty? No rows?

"data input on all forms." Whether all forms allow data input or if you
have some forms the select reports and perform other functions, what
difference does this make in understanding your problem.

So, do you have relationships defined and enforced?

Could you give sample data, current queries, explain how the queries
malfunction, show the current output of these queries, and the desired
output? From that, we might figure out what you want and what the problem
may be. Explain the enforced relationships.

Tom Ellison