creating an ordering facility

[Brian @ NI F2]

The company I work for have asked me to put their catalogue onto a disk
to create an ordering facility.
The best software I have to achieve this is Access, however, I cannot
figure out how to actually creat an order.
The best I can manage is to set my main table up with an order quantity
field, this will be user filled edited in a form, which can then be
printed through a report set to print anything in the ortder quantity
filed of the table as "not Null", this is spot on, it does what I've
been asked to do, but here is the problem, how can I reset/flush/clear
the order quantity to create a new order, so that the products with
quantities from the previous order are cleared?? is there a macro or
VBScript to do it. I'm relitively new to using this type of report and
software, so no doubt there is better ways to do it, if anyone can help
it would be greatly appreciated

 

[Guest]

What you need are at least 2 tables - orders and order details. Take a look at how this is done in the Northwind sample database - it provides a very good example. If you still have questions, post them here.

Scott shearer, MCSD, MCDBA

^^^^^msshearer@@hotmail.com^^^^^
----- Brian @ NI F2 wrote: -----

The company I work for have asked me to put their catalogue onto a disk
to create an ordering facility.
The best software I have to achieve this is Access, however, I cannot
figure out how to actually creat an order.
The best I can manage is to set my main table up with an order quantity
field, this will be user filled edited in a form, which can then be
printed through a report set to print anything in the ortder quantity
filed of the table as "not Null", this is spot on, it does what I've
been asked to do, but here is the problem, how can I reset/flush/clear
the order quantity to create a new order, so that the products with
quantities from the previous order are cleared?? is there a macro or
VBScript to do it. I'm relitively new to using this type of report and
software, so no doubt there is better ways to do it, if anyone can help
it would be greatly appreciated

 

[Greg]

HI Brian
one of the main aims with a DB is to keep all records so information can
be looked at over time.
You dont mention how mnay orders you would average a week this can have
an impact . In any case data should be seperated as best as possible

Customer information
Product information
Orders
order details

As mentioned if you look at the Northwind mdb and look under
tools> relationships you will see tables all joined together, depending
on how much detail you want to keep, is how far you want to emulate this
design but the four tables above are the minimum.

A form is them created to handle the order (a wizard will do good job on
a basic setup ) and for each new order a clean record is produced , or
if it is multiple products involved per order a subform as well (again a
wizard will help here)

BUt the real key is getting the tables set up right the rest is fairly
straight forward

Repost if you have any problems

Greg

 

[beijing3008]

ÄãºÃ

The company I work for have asked me to put their catalogue onto a disk
to create an ordering facility.
The best software I have to achieve this is Access, however, I cannot
figure out how to actually creat an order.
The best I can manage is to set my main table up with an order quantity
field, this will be user filled edited in a form, which can then be
printed through a report set to print anything in the ortder quantity
filed of the table as "not Null", this is spot on, it does what I've
been asked to do, but here is the problem, how can I reset/flush/clear
the order quantity to create a new order, so that the products with
quantities from the previous order are cleared?? is there a macro or
VBScript to do it. I'm relitively new to using this type of report and
software, so no doubt there is better ways to do it, if anyone can help
it would be greatly appreciated