MX Kollection Forum :: Combine 2 fields for drop-down
This thread was displayed: 0 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Dean Collins
02-25-2008 22:05:09 GMT +2
|
Hello!
I have a payments form with a drop-down menu to select a member's name. The "value" for the drop-down is the member's ID and I want the "label" to be a string of the member's first and last names, which are in two separate table fields/columns.
I can do this by hand coding, but can I do it with Kollection somehow -- combine the first- and last-name fields as the label in the drop down?
|
|
|
Guenter Schenk  02-26-2008 14:53:08 GMT +2
|
Hi,
you´ll need to modify the original menu recordset and use the CONCAT function for combining two column, example:
SELECT CONCAT(first_name, " ", last_name) AS fullname, member_id FROM tablename
Once you have this declared, just use the alias column "fullname" as menu label
Cheers,
Günter Schenk
Adobe Community Expert
|
|
|
Dean Collins
02-26-2008 18:26:19 GMT +2
|
|
|
|
