Is it possible to get the value in the form even without saving it?

[Caps]

I have a table (Procedure) that consist of:

[ReportID] - Ref to my Visitation Record table

[Prodtc] - (Text) And has the formula = CONCATENATE( " • ", [Procedure Type], " - ₱ ",[Procedure Cost])

and I have a form (Visitation Record table) that consist of:

[ProcedureID] - (Enum) list of dental procedures.

[Tooth Involved] - Total number of tooth involved

[Prodcost1] - (Price) automatically multiplied the [Tooth Involved] based on the selected [ProcedureID]

[Display] - (Text) And has the formula = SUBSTITUTE(concatenate([ProcedureID].[Prodtc]), " , ", "
")

Now, I tried to put this formula in my [Prodtc] (Procedure table)

But it didn't get the value from the form. Is it possible?

I already tried to do this formula inside my (Visitation Record table), and it works, but I don't want the result, so I'm trying another way but it doesn't work for me.

This is the result I want:

Any help would be greatly appreciated.😊

 

[WillowMobileSys]

Some things don't make sense.  It would be best to show images of your two tables - all the columns and column types.

What table do the [Procedure Type] and [Procedure Cost] columns belong to?

What is the intended relationship between the two tables? (choices below)

• One Procedure row for each Visitation row
• Each Procedure row can be used by several Visitation rows
• Each Visitation row can be assigned to many Procedure rows

[Caps]

[Procedure Type] and [Procedure Cost] belongs to (Procedure table)

Relationship between the two tables

• Each Visitation row can have many Procedure

(Procedure table)

(Visitation Record table)