Query returns nothing when I add a fourth table...

[Grooz13]

Ok I found the problem to my query... I have 4 tbl
Tbl_Submission
Tbl_Production
Tbl_Order


Tbl_Paint

When I query data from the first three tables , it returns my data alright... in the query design, I only Show the Tbl_Paint and now my query return nothing... where is the problem ?

[trb5016]

I would guess (without knowing more details of your tables/data) that there's probably no related record in your 4th table and you have a "Choice 1" join linking them. Try double clicking on the line between the tables and change the choice to the correct "Show All values from ..." options

[Grooz13]

yes the second advice was the good one thank you kind sir