Jump to content

I need a count of OrderParts


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

Recommended Posts

I know this should be super easy, but I'm stumped.

I need to be able to count how many Order parts there are for each Order.

Right it counts all OrderPartsID no matter what Order it came from. I just want how many parts for a certain order.

Order #1 has 3 parts

Order #2 has 4 parts

Order #3 has 1 part

Can't wait till after Christmas when my brain kicks back in.

Thank you for the help.

orderOrderPart.jpg

Link to comment
Share on other sites

In your orders table, have a calc field that uses, Count (OrdersPart::kf_orderID). When seeing it from the Orders table, you will see the related count number for that particular order.

Link to comment
Share on other sites

I am not quite sure what are talking about because you have not provided enough information.

Where are you looking at it from?

I am assuming you mean from the customer layout.

When you are on a customer layout that has a portal etc to show the order, just reference the new calc field and it will give you the count of part records.

Why dont you post a copy of your file.

Link to comment
Share on other sites

Well, the first place I want to refrence it is in the OderParts table layout. I know the count of orderParts now, but what I am looking for is the exact part number.

I need to be able to show "1 of 2" or "2 of 2"

that way when these get printed out everyone will know they have all the parts to the order. Look at my Work Orders(Orders Part) layout to see what I mean.

Thank you again for your wonderful help.

ClothingCompany.zip

Link to comment
Share on other sites

This topic is 5758 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.