Using the customer/order paradigm...
I have an Order details, which is a subform of an Orders form (linked by OrderID). The Order form is itself a subform of the Customer form (linked by PatientID). A Combobox in the Patient form searches for the customer ID record.



I'd like the Order subform to CREATE A NEW RECORD when I start entering information. Instead, it searches for existing records from the customer and I end-up with the order details of previous orders (in the subform of the subform ).

The example database from "Access 2007 the missing manual by Matthew MacDonald" (which I highly recommend), they show this exact scenario (slightly different)... Customer & Order are in one form (who's data source is an inner-join of customers and Orders) with a OrderDetail subform. The subform always seems to create NEW entries. Even on that scenario, I'm not sure how Access knows to create a new ORDER and not a new CUSTOMER .

*ANY* help would be appreciated !!