I am writing a BAQ to show the Jobnumber, Partnumber, revision, quantity, cost we sell the part at, and the total cost of the materials for the part. Everything that I want the BAQ to show is there, but for some reason multiple lines are coming up. I added the ordernum field to the display fields, and I noticed that there are multiple different order numbers that are not actually associated with the job.
Here is the job number (292587) and the only order that is connected to it on job entry.
Here is the result of the BAQ. Notice that the highlighted row is the only one that has the correct order number. The rows have mostly identical information, with only the order numbers and sell price being different.
What could be causing this, and how do I go about fixing this? Here is the rest of the information on my BAQ.
