Access forms to display records

[Srin]

Hi,



I have a form on access, that displays data for the customer and products that he has purchased. I want to set it up in such a way that if I click on the customer it shows all the products he has purchased. And if i click on the products, it goes to the product information page(form).

I currently have a form in which I have put in two text boxes that have the product and customer fields as data source. The form displays records from a query that is used to filter the customer's purchased products sorted ascending.

The form is working partly correct. It displays only one product from the customer that is in ascending order but not all. If I add more text boxes, it displays the same first product repeatedly.

How can I set it up as to display all the products that the customer bought for each customer?

[June7]

Maybe use form/subform arrangement. Main form bound to customers table and subform bound to orders table. What 'product information' do you want to display? This could be included in the subform.

Have an unbound combobox on main form for input of customer to search for. Review http://www.allenbrowne.com/ser-62.html

Really need better understanding of data structure to advise.

[Srin]

Thanks, I understood the idea behind your suggestion.