Simple query question

[pedroccamara]

Hi guys

Don't know what's happening here, but i'm sure it's me. I'm kinda slow today.

I have a table that i've listed with only five columns and the filter is set to, only records from this year.

I've add a table and stablished a relationship between them. It's a very easy process and i'm use to it when i was working with access. 

Somehow, when i add a new column from de new table, it shows me less records from first table, and a lot more than i wish from second.

Both join fields are text formated nnntt and from many to one (automaticaly). What am i missing something here?

Best regards

Pedro

[pedroccamara · Accepted solution]

Ok, i got it (i guess)

One thing is to make the relationship when editing a query and other is when you close it and try to do it after close and aply.

I don't understand why but it's working now. From now on, i'll just do the relationships of querys in editor mode.