[ms office - 2007] how to display a customers order in queries

[smackdvraw]

i want to show a customers order in access but only the customers details and there products they have ordered

[Hecate]

It's difficult to respond without more detail but I would do this sort of thing with a form and subform. The customer's details go on the main form with the order details on the subform linked by a common field such as customerID