Importing matching and adding to value

[Chappythelips]

Hello,

I would like to see the count of the each product i have purchased for all of last year.

I can import last years purchasing excel sheets (over 200) to file maker with no problems but that will make tons of records of the same product with different order counts from different times. I would like to see total inventory purchases of each product. Is there a way to import the records by importing the matching product codes while adding inventory (rather than updating) to the matching record and add remaining data as new record? Is there another function that will look up matching values between records and then add the inventory field for each record for a grand total? Sorry my language use makes the issue so abstract. Thank you in advance.

[sbg2]

Sound like you need two imports. 1 to import the product details and 1 to import the purchase information.

[Chappythelips]

Hello thanks for the advice.

Now i have everything in the file but I would like to display totals of records that have the same product name in the product name field.

Im not having any luck with searching online..

TIA

Russell

[sbg2]

File Attached

MyItems.zip

[Chappythelips]

Wow!! Thank you very much! I can see clearly how to do it now! Its funny, no matter how much i tried to read on doing that its just not the same as seeing an example and how it works to fully understand how to do it!

Thanks again for you help!

Russell