Feb 08, 2017 06:46 PM
I have a table like this:
I want to create a new table that lists all the different Parts with the total of each time that part occurs and the How Many in each row. This is just to create an order list without repeating the rows.
I figure rollups might be the solution but I can’t figure this one out.
Feb 15, 2017 09:13 AM
What tables do you have? Could you explain a little deeper your base (or even share a copy)?
I think you have to create a new View in the Parts table, or maybe an auxiliary table in between. I’d need more understanding of your base :thinking:
Bye!
Feb 15, 2017 05:41 PM
I think I’ve figured this one out. But thanks :slightly_smiling_face:
Feb 16, 2017 12:33 PM
Could you share the solution? I’m curious now! :slightly_smiling_face: ️
Feb 17, 2017 10:47 AM
Well it’s only a crude solution. I group by the product and then use the
count summary on the field that holds the number of each.
What I really want is a new table that lists every part as a new entry with
the sum next to it.
You can see I am just trying to figure out how many of each part I need to
fulfill the current outstanding orders.