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.

2.png

โ€ƒI tried to do this 

1.png

โ€ƒbut giving me this result. I don't know how do to it right.๐Ÿ˜‚

4.png

โ€ƒI'm aiming for this result

3.png

Thank you again in advance for those who will answer this question!๐Ÿ˜Š

Solved Solved
0 2 111
1 ACCEPTED SOLUTION

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]

 

 

View solution in original post

2 REPLIES 2

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]

 

 

THANK YOU SO MUCH! IT WORKED!

Top Labels in this Space