Jump to content

Importing matching and adding to value


Chappythelips
 Share

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

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

This topic is 5700 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
 Share

×
×
  • Create New...

Important Information

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