Display All Records Even If A Row In Child Table Is Empty

[Athar Khan]

Hello, this is my first post here. I created a query which displays unique records from Orders table using OrderID (which is foreign key in Order Details table) BUT the problem is that this query can not retrieve all records from Order table. If any row in Order Details is empty (OrderDetails.OrderID = Null) , then the query can not display that specific record in parent table (Orders). Please help

[Bulzie]

Do a left join between the tables on the OrderID field(arrow going from Order to OrderDetail table.

[Athar Khan]

Thanks for a quick response. If you are talking about relationship, I think it has already a one-to-many relationship with Order Details

[Bulzie]

No not relationship. In your query where you link the 2 tables, double click on the line between the 2 tables and choose the option to return all records from Orders and only those from OrderDetail where they match.

[Athar Khan]

Ok, let me try

[Athar Khan]

Thank you very much. It is solved

[Athar Khan]

Please let me know how can I mark this question as Solved, how can I thank you with an icon or how can I give you star 🌟

[Bulzie]

No need, glad to help. I will mark the thread Resolved for you.