Using access to create a form for order management and fulfillment

[keljar]

Hello everyone. I am extremely new to access and have been tasked with trying to create a new order management system for my company. I had previously set up a system using excel and their online app program and had moderate success with it. But we are coming to the end of the road with that as their are to many limitations for us. From what I read I can make access work for what we need but I was wondering if there are some things that can push us to the next level with it. When I receive an order it will have info such as order #, date ordered, date required, shipping address etc. that I have entered in the first 6 or so columns and each row for that order is the same. Then the next 6 or so columns will be the quantities, part numbers, descriptioins etc that will differ. I wanted to see if there is a way I can create a form of some sort that on the top would have the "header info" (ship to, order number, etc the items that are the same for the entire order) and on the bottom have the quantities ordered and descriptions and the such listed by line item and have a place for the guys pulling to orders to enter what they pulled.

I am hoping this all makes sense.

[amrut]

Northwind daatabase provided by Microsoft is the ideal sample database to look at. Google search and download it.

[keljar]

Thank you amrut that is exactly what we are looking for. Now to learn to adapt it to our needs.