AnsweredAssumed Answered

Inventory Summary Question

Question asked by BenPyke on Mar 13, 2011
Latest reply on Mar 14, 2011 by BenPyke

Title

Inventory Summary Question

Post

I am pretty new to FileMaker Pro so please forgive me if this is a dumb question.  I don't know how to get the relationship between the two tables / layouts.  I have the following inventory example in one table/layout:

ID#:  Type #:  Length:  Qty:

01,    type 1,     10         5

02,    type 1,     20         3

03,    type 2,      5,         1

04,    type 2,      10,        5

05,    type 2,      15,        10

06,    type 3,      5,          5

07,    type 4,      5,          2

What I would like to have in another table/layout is the following

Type:  Total Qty

type 1,     8

type 2,     16

type 3,     5

type 4,     2

What is the relationship criteria to use?

Thanks for your help

Outcomes