Completely confused! Help please

[AndyC121]

I have a database using 4 tables of customer data with a form containing cascading combo boxes, I have read and read lots of posts and examples and totally confused myself. what I'd like to achieve is a report based on the user selections on my form. so to clarify.. whatever my form displays after the user has selected options I want exactly on my report. I don't want the data in the tables to change, any help or pointers and the best solutions would be much appreciated. I have attached my database but removed my data as some is sensitive. many thanks

[orange]

I don't understand why Reports would change the data in your tables. Typically (but not always) a report is used to display data from your tables/queries in some formatted way.

You may get some ideas from:

this site by Martin Green re Access reports
this tutorial from RogersAccessLibrary re database design

Good luck with your project.

[AndyC121]

Thank you for the links.. Ill have a read

[Alex Motilal]

There is basic mistake in the Database design. For each customer you have created a separate table for parts. Instead make a separate table for parts and create a table for orders. Now link the Orders table with Customers and Part tables by creating child keys for customers and parts in the Orders Table.
Alex