Pull report with or without relationships

[Guest]

The relationship in my database is:
Employees Profile Table: One --- to Many: Applications Table

My customer wants the report to show the Employee Profile with applications
if applications exisit OR the Profile alone.

Currently, the profile ONLY appears if there are assigned applications.
First, Is this a relationship question or a VBA question that will pull the
profile whether or not it has assigned applications. I do need to maintain
the one to many relationships between the two tables in order to run all the
other forms and reports.

 

[Marshall Barton]

The relationship in my database is:
Employees Profile Table: One --- to Many: Applications Table

My customer wants the report to show the Employee Profile with applications
if applications exisit OR the Profile alone.

Currently, the profile ONLY appears if there are assigned applications.
First, Is this a relationship question or a VBA question that will pull the
profile whether or not it has assigned applications. I do need to maintain
the one to many relationships between the two tables in order to run all the
other forms and reports.

It might be a relationships issue, but it's definitely an
issue in how the tables are joined in the report's record
source query. Currently you have an INNER JOIN, but you
want an outer join.

Select the connecting line between the two tables, right
click on it and then select the Join Type - Include all
records form the Profile table and any matching records
from the Applications table.

If you do that in the Relationships window, it will be the
default join for any new query you create using these two
tables. However, you'll have to recreate (or modify) your
existing query.

If you change the join type in the query window, it will
have no effect on other objects in your database.