neeed help on invoicing db (newbie)

[sanlen]

Hi,

Base on the below process and the enclosed attachment, could you please advise if I am on the right track? I am pretty new to this Microsoft Access and database management.



I am trying to prepare to a db which for the purpose as below:

- To store all information of the customers
- To store all information of products
- To store all records of products ordering by customers
- To print out or view invoices base on date selection, customer selection,…

The daily process that I am working with is generally as mention below:

Every evening, we make a call to all our customers and asking them what is the quantity of each product that they want to order for next day (not all customer will make order every day). Next day and before we start delivery of the products to customers, the invoices should be printed and signed.

With the tables that I have and the relationship between those tables (attached), I am not sure if it is enough to fulfill my requirements. Your comments will be very much appreciated.

Thanks,
sanlen

[orange]

There are some existing data models at
www.databaseanswers.org

check the list to see if any are appropriate for you. You may need pieces of a few to get what you need, but you should be able to see a designed set of tables and relationships.

Not everyone can read an accdb. I have acc2003 and can not read/open an accdb.

[sanlen]

Hi,

Thanks you very much for the link and sorry for any inconvenience with accdb.

I have attached the mdb version. Your further advise will be very much appreciated.

Thanks,
sanlen