we are trying to create a customer order form based on a customer info table and a subform based on a order details query. however, the order details subform is failing to group the complete order history for each customer in our database together.

for example, the subform should show 2 orders for a customer who has made two separate purchases. however, in our subform, it only shows the record of only 1 order. we would greatly appreciate any help you can provide us with due to our desparate situation. thanx

Do you have two separate tables, one for customers and one for orders?

Normally you would use three forms for this. Either: a main form showing a customer, a subform showing an order, and a sub-sub form showing order datails. Or: a main form showing a customer, a continuous form sub-form showing orders and the ability to show a third form with order details by pressing a button on the order subform or double clicking on the order #.

If you are using only two tiers, you are compressing the order level. This is possible but not advisable.