Relational Serial Number Table Filtering Out Information

[DakotaGoblinMan]

Hello,

I had a question regarding relational tables, and how I should set up this data model.

I have two tables (tblSerialNos and TblNCMDAta) which are set up as the following:

tblSerialNos

Serial_No	NCM_No
ABC123	1001
ABC124	1001
ABC124	1002
ABC126	1003

TblNCMData

NMC_No	Date	Status	NCM_Desc
1001	5/29/23	Open	Broken
1002	6/1/23	Closed	Made Incorrectly
1003	6/5/23	Closed	Broken
1004	6/13/23	Open	Made Incorrectly

I have the relationship set up as one to many (TblNCMData to TblSerialNos)

The problem I am having is if a NCM_No does not have a serial no (is blank) then when I search for any data on a table (For example table has (NCM_no, serial_no,status) it wont pull anything up unless there is a serial number with the NCM_No. I have it seelcted to show data with no value. 

Is this an issue with the relationship of the data or do I need to merge the tables instead? 

[Anonymous]

HI @DakotaGoblinMan,

In fact, I think this result is expected for power bi relationship mapping works. These records which not matched relationship key will be mapping to the 'blank' serial no group.
Regards,

Xiaoxin Sheng

[DakotaGoblinMan]

This is how I currently have the relationship setup.