help with design

[jtahos]

Hi and thanks for takeing the time to help me with my question. I'm
trying to creat a db for the resturaunt i work for to keep track of
prices and ordering. the info that will be needed to keep track is: the
companies we deal with, the products wich are broken down to 3
catagories : Frozen, Refrigerated, Dry Goods.

we'll be getting a quote for a price from suppliers 2 times a week; and
will be placing a order twice a week.

can someone give me derection on how to start this project or if they
know of any links to simler projects or books to recomend i would realy
apretiate it. Oh by the way i'm useing access 2000
Thanks in advance John

 

[John Vinson]

Hi and thanks for takeing the time to help me with my question. I'm
trying to creat a db for the resturaunt i work for to keep track of
prices and ordering. the info that will be needed to keep track is: the
companies we deal with, the products wich are broken down to 3
catagories : Frozen, Refrigerated, Dry Goods.

we'll be getting a quote for a price from suppliers 2 times a week; and
will be placing a order twice a week.

can someone give me derection on how to start this project or if they
know of any links to simler projects or books to recomend i would realy
apretiate it. Oh by the way i'm useing access 2000
Thanks in advance John

Well, it just so happens that the main demo database distributed with
every installation of Access - northwind.mdb - is a restaurant
supplier ordering database. Try opening it and see if it gives you
some ideas!

You will clearly want to modify it; you can get some resources for
learning to do so from http://www.mvps.org/access or from the
Resources link at
http://home.bendbroadband.com/conradsystems/accessjunkie.html


John W. Vinson[MVP]

 

[Haris Rashid]

hi,

you need to create the tables to store the information and link them. The
tables would be Products, Categories, Suppliers and Orders.

Orders would link suppliers (customers) to products.

This should get you started. Let me know if you need more help.
(e-mail address removed)