Query with filters not working!!!! I made a video to explain :(

[SebastianColombia]

First of all, god morning/afternoon/evening as the case may be. I've been struggling with a query that hasn't worked. I made a video in order to try to explain what's happening. Hope you can help me.



Thanks and excuse me for my English!!!

https://www.youtube.com/watch?v=Eh7G...ature=youtu.be

[Perceptus]

https://support.office.com/en-ca/art...1-07061a1478f6

Hopefully that comes in your language of choice.

The issue I think you are describing has to do with having a 1 to many and a 1 to 1 relationship.

Initially you are only showing data from a small relationship, but as you set your query to include parts from other tables, there are more than 1 match that can occur. You are seeing this.

[SebastianColombia]

Sir thanks a lot for the link!!! Im going to read it!!! thanks!!!