I have a custom table that I'd like to add a field to that concatenates the values from a related row in another table. For example, in a table that contains line items for an order, I want to add a field that displays the name and description of an item. The name and description exist on the Items table. The 'Line Item' table has a relationship connection to the Items table and the Orders table.
My first instinct is to create a calculated field that concatenates the item name and item description, but I'd like to avoid adding those columns to the 'Line Items' table if possible.
What's the best way to accomplish this?
Not sure how the relationship in your system works, it sounds like you have 3 or 2 tables?
Anyway, use power fx formula column in the target table:
formula example:
concatenate('Item'.name, 'Item'.description)
feel free to add any fixed seperator in the concatenate function to divide the text
Never use calculated field, they are **bleep**
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2