Linked tables

[koncreat]

I have a main table and a second table that are linked by the primary key Issue_Number from the main table. The issue number field is an auto number field.

Main table name is P1_active_sorts
Secondary table name is P1_sorts


When a user starts entering a record the issue number populates with the next number in sequence. The second table is in a subform.

The problem I have is that when i run a report that pulls information from both tables the report is blank unless I go to the first record in the second table and enter at least a zero.



I have attached a copy of the database and the record entered does show the problem i have if you go to reports and run the Gate Break Report and use 2/17/17 as the date.

[koncreat]

Here is a copy of the database

[Bulzie]

In the query for your report, use a Left Join (arrow goes from P1_active_sorts to P1_sorts). This will give you all records from main table and if there is no record in 2nd table, those 2nd table fields will be blank.

[koncreat]

That worked thanks!