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.😂
I'm aiming for this result
Thank you again in advance for those who will answer this question!😊
Solved! Go to 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]
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!
User | Count |
---|---|
25 | |
14 | |
4 | |
3 | |
3 |