Fighting with a summary field, again
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 associ...
Forum Discussion
I'm assuming that Quote is the parent table of orders. In that case, if you navigate to the relationship and create a Summary Field - select combined text, and choose the Statys, that should give you a text string separated by semi colons of all your status'.
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------
- I tried that approach, but there is nothing in that approach to group the combined text field by quote.
I may not have stated, the overall objective is a field that returns the unique statuses for all orders in a quote. Or more accurately, I am trying to find a way to determine when all of the orders in a quote are in a closed status.
If I created a separate table for quotes, used the quote as the key and created the combined text field in the new table, would that give me the results I need?
------------------------------
Paul Peterson
------------------------------- MarkShnier__You
Qrew Legend
This does not make sense.
I tried that approach, but there is nothing in that approach to group the combined text field by quote.
If this combined text summary field is on e Quote table, then all the combined status are for that single quote.
But if your real purpose is to know when all the orders have been close, why not just make a normal summary count of the number of Orders, and then make a summary count of the number of closed orders.
If the [# orders ] >0 and [# closed orders] = 0, then all orders are closed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- The tables are based on orders, not quotes. At the moment there is not a table of quotes.
------------------------------
Paul Peterson
------------------------------
