Microsoft Access A to Z: Finding orphan records using join properties

[@owenwaldo]

Thankful for you Lisa!!!

[@moodkn]

Thanks Madam!

[@lfriedrichsen]

Thanks. You can find all of my TH-cams and playlists at learncs.w3spaces.com/

[@senometalinc.6719]

Hi,
How do you display other fields from the foreign key?
For example:
Customer Table:
CustomerID (primary key)
CustomerName
Link (1 is to many)
Invoice table:
Invoice number (primary key)
CustomerID(foreign key. Dont want to display this)
CustomerName (i want this to display)

[@lfriedrichsen]

If using Access, you drag the fields you want to view into the query grid. If a field is in the query grid that you do not want to show, you can delete it from the query grid or uncheck the Show check box for that field/column.
If using SQL, you reference which fields you want to select in the SELECT clause of the SQL statement.
Keep watching my TH-cam series as I show how to select fields in my TH-cams on queries.

[@senometalinc.6719]

@@lfriedrichsen am using ms access. Is it possible to directly display the CustomerName field in the InvoiceTable instead of making a QueryTable?

[@lfriedrichsen]

​@@senometalinc.6719 There are queries and there are tables, but there is no such thing as a "QueryTable".
Also, you don't want the Invoice table to directly store the CustomerName given that data is already stored in the Customers table. You could, however, use Lookup properties on the CustomerID field in the Invoice table to "look up" the CustomerName field data from the Customers table. Watch my TH-cam on Lookup properties if you want to explore that.