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?
