Calculated concatenated field with linked fields

[PatKwi]

Hi is it is possible to create a calculated concatenated field from three other fields in a table when one of the fields is a linked field?

I need to create a new concatenated field in my ITEMS table:

"Full Item Name"

Which pulls from the following fields:

"Item Name"
"Packaging Type"
"Location"

So I want to see something like this:

Cider~Cans~Texas

But "Packaging Type" is a linked field from my table PACKAGING and "Location" is a linked field from my table LOCATION.

I don't want to see something like
Cider~2~38

Do you have a general example of guide to created these calculated concatenated fields that also deals with linked fields?

Thanks.

 

[deep64blue]

Do these "Full Item Name" details change once they are created??

 

[PatKwi]

No they should be static