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.
Back
Top