Search Filter Not Work

At a guess I would say your relationships between tables is not correct.
Post a copy of your SQL syntax and what your searching for

Try to enable SQL debugging to see the actual SQL query produces:

http://xlinesoft.com/phprunner/docs/debugging_tips.htm
This can point you in the right direction.

Pardon my English ...
sorry, exhausted my attempts. I retired all relationships and i tried only with the WHERE clause but the problem still continues. As recommended me, i setting the DDEBUG parameter for true, see the result:
select GroupID from sistema colportor_ugmembers where UserName='teste@teste.com'

select TableName,AccessMask from sistema colportor_ugrights where GroupID in (-2)

select count(*) FROM clientes where clientes.Email_Colportor='teste@teste.com'

SELECT ID, Nome_Razao, Colportor_que_contactou, CPF, Inscricao_Estadual, Endereco, Bairro, Cidade, UF, Pais, Complemento, Telefone_fixo, Celular, CEP, Mapa, Observacoes, CNPJ, Data de Nascimento, Estado_Civil, Profissao, Filhos, Quantidade, Situacao, Data do Pagamento, Email, Condicao_Pagamento, Email_colportor FROM clientes where clientes.Email_Colportor='teste@teste.com' ORDER BY 1 ASC
The primary key is ID and on the List page: before SQL Query i have: $strWhereClause = "clientes.Email_Colportor='".$_SESSION['UserID']."'";
a 'colportor' can have multiple clients, however each 'colportor' can only see their own customers. The search does not work in this case.

It's not really clear what is the question. I understand that your current SQL query is as follows:

How do you want to change this query?

The problem is that when I type a name in the query, brings as result all records, always.

Run this query manually against your database. Does it still brings all the records?

I had a similar problem when using ID's in my main jobs table.

I used cross table searching, so in my list page, I can see the Customer_Name that has been saved, but when I search, I am really looking at the customerId against the customerId in the customer table and displaying all jobs related to that customerId.

It works great.

It might help to export an SQl of the structure of your tables and post it so that we can take a better look.

Does the fact that the field "Email_colportor" the Customers table is not the primary key it gives this error? Because when I insert on the list page: before sql query: $strWhereClause = ("clientes.email_colportor = '". $ _SESSION ['Userid']. "'") the filter search field no more not work.

Thank you all for the help.

I found the problem. Was in access permissions to the tables.