add more lookup display fields

danels · Post by **danels** » Sat Jan 04, 2014 8:14 am

any ideas how to add more display fields?.
In phpmaker program on lookup section there is only 4 Display fields provided.
Display Fields

Display fields #1
Display fields #2
Display fields #3
Display fields #4

is there a way if i want to add some more for me to be able to display more than 4 lookup Display fields from my database?

Thanks in Advance

danielc · Post by **danielc** » Sat Jan 04, 2014 10:51 am

Alternatively, you may consider to create another field to store your lookup and use view to concat the two fields to display more than 4.

danels · Post by **danels** » Sun Jan 05, 2014 8:41 am

i dont understand how to do it. could you please elaborate. and show me step by step.
Actually i just need to add 1 more data to the lookup. Thanks in Advance

danielc · Post by **danielc** » Mon Jan 06, 2014 11:52 am

field 1 setup to display 4 fields.
field 2 setup to display 1 field. (need your table to setup additional field)
concat field 1 and field 2 in your view, like
CONCAT(field1, ",", field2) AS field12

danels · Post by **danels** » Mon Jan 13, 2014 6:47 am

thank for your kind answered danielc. btw where should i put the concat command? because i would like the user can select the concat lookup field , and auto fill the fields. Thanks in Advance

danielc · Post by **danielc** » Mon Jan 13, 2014 1:25 pm

CONCAT is used in your sql to create a view. See http://dev.mysql.com/doc/refman/5.0/en/ ... ion_concat

bioaroma · Post by **bioaroma** » Wed Dec 13, 2017 5:15 am

Did you solve this
I have the same issue
I know how to concatenate field but not clear where should be placed the code
and also what is the link between views and Lookup table?

mobhar · Post by **mobhar** » Wed Dec 13, 2017 6:39 pm

bioaroma wrote:
what is the link between views and Lookup table?

It means, you may simply use a "Database View" in "Table name" directive of your "Lookup Table" setup.