How to show all records in table linked to table with fewer records

Discussion created by jeffmdm on Apr 15, 2016
Latest reply on Apr 16, 2016 by jeffmdm

I have a table with 1800 records (all product skus, archived and current) that I have linked with a relationship (using sku as key) to another table (1300 records of current products only) that doesn't have a record for every sku.  When I use a layout to try to look at data from both tables together I am limited to the number of records (1300) in the second table.  How do I set it up so that I can see all 1800 records, including possibly blank fields from one table?