Add multiple fields to a dropdown list
Hello,
I am hoping someone could help me out with a problem I am having.
I would like to add two fields separated by a ( - ) to a dropdown list in a subform.
This code,
- jobs = New_Project[ID != 0 && Job_Status == "Open" && Job_Type == "Construction" && Client_String == input.Owner];
- Crew_Time.Job_No:ui.add(jobs.Job_Number.getall());
returns a list which looks like this: S17565
S17586
S17585
which is ok but I would like to add the description to help differentiate our job numbers.
when I try,
- jobs = New_Project[ID != 0 && Job_Status == "Open" && Job_Type == "Construction" && Client_String == input.Owner];
- Crew_Time.Job_No:ui.add(jobs.Job_Number + " - " + jobs.Description );
I will get a dropdown containing only a single row: S17585 - Overland Conveyor
when I tried,
- jobs = New_Project[ID != 0 && Job_Status == "Open" && Job_Type == "Construction" && Client_String == input.Owner];
- Crew_Time.Job_No:ui.add(jobs.Job_Number.getall() + " - " + jobs.Description.get());
I just get a single line containing list of the job numbers then the " - " then a list of job descriptions.
is this a limitation of ui.add?
thanks,