I am struggling with an ASP page for my database, so in the mean time I am using an Access 2000 produced web page.

I need to show the customer data from Table1, and then details of the items they have purchased (Which has its own set of fields)from Table2.

I have been able to do this as a form in Access as you can create subforms, but this option is not available now.

If someone can please point out how to do this I would be greatly appreciated.