Relationships

[Guest]

We have two tables, one with our complete budget shipments for the year by month and another with our year-to-date actual shipments. Our primay concern is with the part numbers. Our budget table contains all of our part numbers, and our actual table contains only the part numbers that we shipped during the year. We have created a one-to-many relationship between the tables. We are the process of creating a query to match up all of the part numbers budgeted versus the actual part numbers shipped. The problem is...when a part number is not actually shipped during the month, that part number with the budget is not showing up. Do you have any suggestions?

 

[Lisa Petrera]

The best way to handle this, if I understand your dilema
properly, is to force all of the results from one table
even if there are no records in the other. Click on your
relationship and change your 'join type' to be all records
from your main table. Then use a query, setting criteria
in your main table, to draw your results. Hope this
helps.

-----Original Message-----
We have two tables, one with our complete budget

shipments for the year by month and another with our year-
to-date actual shipments. Our primay concern is with the
part numbers. Our budget table contains all of our part
numbers, and our actual table contains only the part
numbers that we shipped during the year. We have created
a one-to-many relationship between the tables. We are the
process of creating a query to match up all of the part
numbers budgeted versus the actual part numbers shipped.
The problem is...when a part number is not actually
shipped during the month, that part number with the budget
is not showing up. Do you have any suggestions?