Get details from selected enum list and display

This is my enum list and I wanted to display the selected [ProcedureID] along side with it’s price [Procedure Cost] in the bottom.

I tried to do this

but giving me this result. I don’t know how do to it right. :joy:

I’m aiming for this result

Thank you again in advance for those who will answer this question! :blush:

Please create a concatenated virtual column in the parent table (I believe its name is “Procedures” table)

such as [ProcedureTypenCost] with an expression

CONCATENATE( " * ", [Procedure Type], " $ ",[Procedure Cost])

Please replace $ with the currency symbol you use.

Now use this column in the field “Selected Procedure Details” in the child table with an expression something like

[ProcedureID] [ProcedureTypenCost]

3 Likes

THANK YOU SO MUCH! IT WORKED!

2 Likes