2. PHPRunner General questions
  3. combine 2 fields into dropdown
This topic is locked

combine 2 fields into dropdown

 		6/28/2006 3:49:37 AM
PHPRunner General questions
kujox author

I've just bought this after moving from hand coding and it has saved a lot of time
How can I add 2 fields into a drop down box
ie: i have a dept number and a description, i want the dropdown to read
'12 sales'

'14 purchases'

'21 admin'
Alexey admin 6/28/2006

Hi,
select <Custom expression> in Display field box on Lookup Wizard dialog.
Enter this in Custom expression field:

concat(`dept number`,' - ',`description`)
where dept number and description are your actual field names.
kujox author 6/28/2006

Thanks
I am still finding my way about in this.