Summary fields do not seem to be my thing. I'll start with the desired result then share what I have tried. I need to create a field that will contain all of the status for all of the orders associated to a quote. Each order has an order number and a portion of the order number is the quote number. The quote number is also a field in the table. My first attempt was to create a field that would extract the quote number from the order number, create a combined text field on the status field where the quote number is equal to the value in the field I created to extract the quote number from the order number. This method returned the status for each order but not a combination of all of the statuses for the orders associated to the quote.
Where did I go wrong?
------------------------------
Paul Peterson
------------------------------
