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.
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.