Hi. I am currently creating a database for all of my customers and the products that they order. I have made a form that contains a link to open a report. When this is clicked, the report pulls out information such as telephone number etc from the form and into the report. This all comes from the "Customers Main" table. Now, I have a second table which contains all of the products which the customers order. The problem I am having is that I want the report to display the products of a certain customer, but I don't know how to do it. I don't want to go about the approach of what I did before which is that I have another form which leads to another report, as I want all the data in one report. Any ideas how to go about this.
Many thanks,
K Baker.
Many thanks,
K Baker.