Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 6486 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

  • Newbies
Posted

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

  • Newbies
Posted

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

This topic is 6486 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.