Single Query to fetch same fields from same/different rows to multiple fields on a access form

Question

I have a query where there is a criteria to look for a order number field on the form and fetch the customer name,date of order and price.

Now I have 10 order number fields on my form which are different from the first order number. How can I write a query to fetch the customer name,date of order and price for those?

I do not want to write 10 of the same queries. Help!