I warmly greet you members.
I am working on a project in PHPMaker with a Lookup field that links to the Customer Table.
I have the following settings for the field:
1). Table name: tb_customer
2). Link field: id
3). Display Field #1: customer_name
4). Distinct: Yes
5). Allow add: Yes/True
6). Allow sort/Search: Yes
7). Edit Input Tag/Field: Text
8). Use Lookup Table: Yes
9). Force Selection: Yes
The challenge I have is that the Lookup Field use “START WITH” search operator instead of “LIKE”. For example if the Customer name that I intend to search for is “Ssenfuma Paddy Kaye”, when I use the search word “Paddy” or “Kaye” no record is returned. It only returns the record if I start with “Ssenfuma”
I seek assistance on how to fix this so that the “LIKE” search operator is what gets used.
Thank you!