Lookup table in form

[bar891]

Sorry for being a newbie noob, i'm using access 2007 and have setup my databases. It is a basic inventory control setup with incoming stock & invoicing out stock. As i have alot of stock products i can use for different jobs, i want to design a form for when i am doing my orders that i can select a dropdown box which will have a produst list with item number, description,units in stock so i can pick which one i want and then move onto the next line and do the same until i have selected all the products i want then print the packing slip out.I don't want anybody to do it for me, i just need a prod in the right direction.

Many Thanks

 

[georgedwilkinson]

Look up:
Main form/Sub-form
Tab stops
Combo Boxes
queries
Data normalization

You won't make your goals without these concepts.

Your "invoice" needs to have a header (main form) and detail (sub-form) records. Detail records will point at inventory records which may point at one or more pricing records over time, which in turn might point at one or more "customer" records, over time. You'll want to understand the different kind of action items for various objects on forms and utilize that to calculate prices and lock an invoice once it is finalized. It can get pretty complex.

It would be wise of you to look at the pre-packaged stuff before even starting. I think there is a built-in sample (Northwind?) when you install Access. I also believe there is at least one sample in the samples forum on this site that will be of help.

There are also some spiffy tutorials on the Microsoft Office site. You should go through as many of those as you can stand.

 

[bar891]

Look up:
Main form/Sub-form
Tab stops
Combo Boxes
queries
Data normalization

You won't make your goals without these concepts.

Your "invoice" needs to have a header (main form) and detail (sub-form) records. Detail records will point at inventory records which may point at one or more pricing records over time, which in turn might point at one or more "customer" records, over time. You'll want to understand the different kind of action items for various objects on forms and utilize that to calculate prices and lock an invoice once it is finalized. It can get pretty complex.

It would be wise of you to look at the pre-packaged stuff before even starting. I think there is a built-in sample (Northwind?) when you install Access. I also believe there is at least one sample in the samples forum on this site that will be of help.

There are also some spiffy tutorials on the Microsoft Office site. You should go through as many of those as you can stand.

I have based my database on the Northwind example so i have the main structure in place, i just want to make the order form more user friendly to my situtation.