Printing entire customer records gathered from main form and two sub forms

[falahsalih]

H everbody,
I'm new in access. I have a data entry form consists of a main form ( involves some information about the costumer) linked to a sub form (order ID and Date), also the sub form is linked to another sub form called order detailed, where, when I choose the costumer, the order sub form shows me the number of the orders that belongs to that costumer, and also when i navigate through the the orders, the corresponding details come out from the order details sub form. i.e., only the corresponding details of specific order come out at each order record navigation. What i want here is some suggestions in how print out one costumer information with one order and the corresponding details that belongs to that order in a report. Your help really appreciated.

[amrut]

Create the query and use the "Group & Sort" option in report and group by Customer and the corresponding details that belongs to that order will be listed below it. Then filter the report when opening it so that only the required customer's orders are printed. See http://www.techonthenet.com/access/r...filter_rpt.php

[falahsalih]

H everbody,
I'm new in access. I have a data entry form consists of a main form ( involves some information about the costumer) linked to a sub form (order ID and Date), also the sub form is linked to another sub form called order detailed, where, when I choose the costumer, the order sub form shows me the number of the orders that belongs to that costumer, and also when i navigate through the the orders, the corresponding details come out from the order details sub form. i.e., only the corresponding details of specific order come out at each order record navigation. What i want here is some suggestions in how print out one costumer information with one order and the corresponding details that belongs to that order in a report. Your help really appreciated.

I tried what you have suggested to me, it works well with the customer record set, however, when i select the second row of the order sub form , it keep show me the first row and its corresponding information of the order details in the report. Can more help please ??

[amrut]

You can add the OrderID to the groupby clause to achieve this. Another option is to create a sub-report for the order details and use it in this report with the Order Id linked to foreign key in order details.

[falahsalih]

You can add the OrderID to the groupby clause to achieve this. Another option is to create a sub-report for the order details and use it in this report with the Order Id linked to foreign key in order details.

Ok, let explain more, the problem is with customer vs (order and order details) not order vs order details
when i move to the second row of the orders table (from data entry form) which is refer to the second order of the same customer name, it shows me the first order and its details in the report

[amrut]

when i move to the second row of the orders table (from data entry form) which is refer to the second order of the same customer name

I am unable to follow this. Is the report loaded when you move to next order ? Can you post your db or screenshot of what is happening/not happening ?
The report can show all the orders belonging to the customer or a particular order based on the criteria you decide. The field you decide to apply criteria should be in the report.

[falahsalih]

I am unable to follow this. Is the report loaded when you move to next order ? Can you post your db or screenshot of what is happening/not happening ?
The report can show all the orders belonging to the customer or a particular order based on the criteria you decide. The field you decide to apply criteria should be in the report.

armut , please have a look at my new post about the same issue https://www.accessforums.net/access/...tml#post225927