auto-fill form

[ga11ardo]

Ok I am totally lost here. My boss gave me a paper copy of their current order form. It has fields to fill in the customer company name, billing address, shipping address, product information (catalog #, description, price, cost, ect.) order information (order number,quantity of each product purchased) and payment method and details. He then told me to create this order form using access so it could be filled out on the computer and printed with all the information. (note, the same company will have many different orders) I have no idea how to set this up or anything. I am an intern and know VERY little about access and database. please help

 

[Uncle Gizmo]

I would you suggest that you start off by exploring the features of the demo database provided by Microsoft called "Northwind database".

If you decide to use this database as is, then there is one small problem that you should be aware of details here. There may be other problems with the database because it is not constructed for use, it is constructed to demonstrate various approaches and techniques.

 

[MStef]

As I can see, you are an beginner in Access (and Relation Database).
I suggest you to learn somthing about DATABASE NORMALIZATION, (it is
very important.
I made a smoll Demo example for you.
Look at "DemoCustomerOrderA2000.mdb" (attachment).
You have to adapt it as you need.
There you have got 4 tables, 2 queries, 5 forms, 2 reports.
Open form "AdministrationMenu" adn try.
Look at VBA, Relationships.