Search lookup table

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
netsam
User
Posts: 19

Search lookup table

Post by netsam »

Hi, I have a field in a table "id_customer" linked to "user" table, where I have customer's name, by mean of "use lookup table" check.

I want to search the customer name in "order" table with default input search text above the grid.

If I write the customer name I have no result.


mobhar
User
Posts: 11734

Post by mobhar »

Just enable the following setting from "Fields" setup -> "Lookup Table":

  • Allow sort/search
  • Text input for search

Also, enable "Ext. Search" under "List Page" column of your "Fields" setup for that "id_customer" field to display this field in Search Panel section.

afterwards, regenerate ALL the script files again.

This will make the field become Textbox instead of using Combobox, and you may input and search based on the customer name from the Textbox.


netsam
User
Posts: 19

Post by netsam »

Ok, thanks. It works.


Post Reply