Cascading Dropdown Concat Help

I have a cascading dropdown set up appropriately. However it is showing the id as the label.

The id comes from another table. This is my set up

Table 1: EMS Supplies
id: 1
name: BVM

Table 2 EMS_supplies_sizes
id:1
parent_id:1
Size: 1
Size: 2
Size 3

Table 3: sizes
id:1 size: Adult
id:2 Size: Child
id:3 Size: Infant

So I have a databasejoin element for EMS Supplies then a cascadingdropdown for ems_supplies_sizes

When I select BVM in the databasejoin element I get the following in the cascadingdropdown.

1
2
3

I need this to show in the options of the cascadingdropdown.
Adult
Child
Infant

Any help appreciated
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top