Re: [philb] Multiples field from on table populate one field from an othe table
Hi Philippe,
You're close. Under list options selected "Get options from MySQL Query (advanced)" and enter this (use your own table prefix and table name instead of cms_tablename):
SELECT num, CONCAT_WS(" ", code, produit, format) FROM cms_tablename
The CONCAT_WS mysql function means "concatenate with string" or "join these fields together with this first value". So in the above example it would join code, produit, and format together with a space and return that as the pulldown "label". I set the pulldown "value" as the num field. If you want the joined value for both just use this:
SELECT CONCAT_WS(" ", code, produit, format), CONCAT_WS(" ", code, produit, format) FROM cms_tablename
Hope that helps! Let me know how it goes.
Dave Edis - Senior Developer
interactivetools.com