What form is best for a supply/order list?

[Guest]

I want to set up a database where I can place multiple items ordered and
track when the order is complete. Example; if I order XLarge gloves and
Small gloves, on the same order, they will have different catalogue numbers
and prices but still be on the same order. What is the best application for
this?

 

[John Vinson]

I want to set up a database where I can place multiple items ordered and
track when the order is complete. Example; if I order XLarge gloves and
Small gloves, on the same order, they will have different catalogue numbers
and prices but still be on the same order. What is the best application for
this?

Access would be fine for this; you say what "form" is best - typically
an Access application will involve multiple forms, which are just
windows, tools to edit data in tables.

Take a look at the Northwind sample database in Access. It has an
Orders application specifically for the situation that you describe.

John W. Vinson[MVP]

 

[Guest]

How do I locate the Northwind sample database in Access?

 

[John Vinson]

How do I locate the Northwind sample database in Access?

If you installed Access with the "complete" option, it's in the
Samples folder: something like \Program Files\Office\Samples

If you took the partial install, you can get out your Office Pro CD.


John W. Vinson[MVP]