I am using CR 10 with Windows XP!
I am trying to build a report that takes the parts that were sold this year and then breaks them down to their compoents so I can see what built them. I need to get the SUO code of the componets. My problem is that the way the tables have to be linked, when I pull the SUO code from the PartMaster table I am getting the SUO code for the part the was sold not the componets of the part. I can't link the tables any other way because otherwise I won't get the proper parts that were sold for the year. So is there any way to get around this situation.
Thank you for your time!
I am trying to build a report that takes the parts that were sold this year and then breaks them down to their compoents so I can see what built them. I need to get the SUO code of the componets. My problem is that the way the tables have to be linked, when I pull the SUO code from the PartMaster table I am getting the SUO code for the part the was sold not the componets of the part. I can't link the tables any other way because otherwise I won't get the proper parts that were sold for the year. So is there any way to get around this situation.
Thank you for your time!