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.

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.

That works great!, but now I need to be able to find out what part number I am looking at.

example.

Part 1 of 2

Part 2 of 2

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.

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