wondering if I can get a hand combining a field from multiple related records into a single field.
I have two tables:
- Order Items - Items within each order. Each order will have an item record in this table for each item.
They're linked by an order ID
I want to create a textarea field within Orders that lists the name of each product (one per each order item).
I ultimately need to be able to export that order including the field containing all of the items from the related record
I've tried calculations and looked at portals, but haven't been able to work out how to get what I'm after in an export-friendly format.
Any ideas? Thanks!