Search a client from the name or surname

[Former Member]

Hi,

My English is bad, sorry.

How do I find a client from his name or surname (or part of this), and show me all matches. The clients are in the database.

Thanks,

Regards,

Rubén Gutiérrez.

[gill367]

can you elaborate the problem more.

what type of client you are referring to..

thanks

sarbjeet

[Former Member]

Ok Sarbjeet,

You can can search a client for NIF, but also can search by name or surname. The next image shows the View:

http://www.imaxenes.com/imagen/fc1qe504t.jpg.html

The access to the database I've done with RFC calls through JCo's.

The idea is that when you enter the name or surname/s of the client to display the matches in some way, and to be selected as desired.

In the database, the table is ZFCC_CLIENTE, where are the NIF, name and surnames of all clients.

Regards,

Rubén Gutiérrez.

[Former Member]

Thanks, I solved the problem.

Regards,

Rubén Gutiérrez.