Need some help w/ a query with 3 tables

  • Thread starter Thread starter JNariss
  • Start date Start date
J

JNariss

Hello,

My database has 3 tables that I am trying to show in a query but
nothing comes out of the query if one of the tables has no information.
Let me explain further.......

Table 1: Request (this table shows details of a request that has been
submitted by a user)

Table 2: tblRequestActions (this table shows actions that happen to the
request after the request details have been filled out. For example
when the request is sumitted and moved into production it has a date
for each and an authorized by name)

Table 3: Problems (this table was created for a user to enter a request
Id and then enter the name of the problem [after it has been tested by
the Analyst] and the problem description

I can easily create a query between table 1 and 2. However when I try
to add table 3 in and a request id has not yet been entered into that
table then nothing at all comes up on the query.

I would like to some how be able to show the users of this database all
the details of a request and it's actions and whether or not if the
request has problems. So if fields within the tables are blank they
should show up in the query that way and/or if a request does not have
a record in the problem table then I just want those fields to show up
blank.

How can I make this happen?

Or I am open to other solutions if you feel this may be too confusing.
I feel this should be done easily but I'm always surprised.

Thanks,
Justine
 
Back
Top