Dear All,
I have seen some examples about how light switch can generate Auto complete field (Automatically without programming) through connecting two tables.
Now, let’s say that I have a table (which is based on a DB view that I created), in this table I have more than 8000 customer number. I need to make this field an Auto complete field, meaning that when the user try to write a customer number a drop down list will be generated to show all the customer which start with the number that the user write.
How can I do this If I ONLY have one table, there is no relation with other tables???
I was able to create some Auto complete boy manually through writing the option which the drop list should have. but I cannot write 8000 customers numbers manually :(
Would you help me in this issue?
Ps: See attched photo for a Auto Complete field which I created manually.