Displaying records in a query from two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have two tables - Invoice Table (primary) and Debit_Credit Note Table with
a 1 - 1 relationship based on invoice number. Normally I have noticed from my
work with Access that records are only displayed in a query sourced by both
tables for invoice data that have been appended on both tables.

However, I was wondering if there is somenthing that can be done to make all
records on the primary table displayed in the query regardless of whether or
not there is a corresponding record in the other table.

Your assistance will be deeply appreciated.
 
If you right click on the relationship in the query editor, choose
properties. There is an option to show all records from 1 table, and only
matching records from the other.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
manual deletion of records in datasheet based on joined tables 5
Remove a result from a query 2
Searching for Missing Data 1
Unable to append due to key violations 1
Have both records from two queries/tables under one Query without related fields. 0
Transaction Processing Combing Record Types 2
Need to compare 2 tables and only pull certain records from one ta 3

Back
Top