Hi everyone.
I have a data type “tb-aux-props”, inside of them i have a related field “imovel-tb” that contains properties and a “imov-tcod-txt” that contanis the code of the property in text format
visualy both show the same information, one show property code and another show the property related.
I would like to make a page with a text that shows if i have entries where the text code is diferent of the property code
I was able to make a repeating group that’s do a search for in “tb-aux-prop” and put a text field with this parameter
but i don’t know how to filtered for just show the “No“ lines
Many thanks
E ae Eduardo! 
Do a search of tb-aux-props
where
imov-tcod-txt <> imovel-tb’s Code
Faz sentido!?
Hi rpetribu,
I saw that you are from Brazil, but I don’t know if it’s okay to speak portuguese here, of course feel free to answer in portuguese or english.
First of all, thank’s for your help, and about your ideia, is the first thing that i try but is not possible
I created a text and asked to make a search on tb-aux-prop and put a constrain:
imov-tcod-txt <> …
but don’t apear nothing that releated for the same table like your idea.
Maybe i lost some thing.
Yes, you’re right. You can’t reference the same object within its own search.
To do that, you need to perform a “Search for” first, then use :filtered and select the Advanced option.
Let me know…
It works !!!
rpetribu, thanks for your help, I’m tring to solve this whitout sucess for long time kkkkkkk
I will post here just to be an example for anyone that have the same problem
I created another app to make tests , on this app you will see that have 2 tabls to simulated my problem
follow have your soluction
The result is 2
Thanks a lot
1 Like
