Question Steps involved in creating sales Invoice in ms access 2007

[emphyda]

Hi all,
I am a newbie, I would very much appreciate who can give me steps involved in creating a sales invoice for a pharmacy shop with four main tables, namely, the customer table, the invoice table, the line item table and the drug detail table.
Thanks.
Emphyda

 

[RainLover]

You appear to be off to a good start.

Your Tables appear correct.

What/Where do you want help with.

 

[emphyda]

The relationship between the tables are Customer(one) to Invoice(many), Invoice(one) to Line Item(many) and Drugs Details(one) to Invoice(many). I suppose I am right here.
My project is in two; wholesales and retail sales. The wholesales will involve the customer table while the retail sales will not.
Presently I want to work out that of the retail sales.
The next thing I want to do is to make the Drugs Details table the main form that will display details of the drugs to be dispensed. I will want to select from a dropdown combo list, while the invoice and line item tables will be sub forms. How can I attach the two sub forms to a main. The tables

INVOICE
Invoice_No (pk)
Date

LINE_ITEM
Invoice_NO
GRP_Code
Qty_Sold

DRUGS_DETAILS
GRP_Code (pk)
DRG_Name
Retail_Price
Available_Qty.

Thanks

 

[RainLover]

You have your mind in the right place but the design of the individual tables could be improved a lot.

I do suggest that your Main Form be a Menu so you can decide which form you wish to open first. It may be the Invoicing or perhaps you may wish to add a new drug.

I do suggest that you go to the link in my signature which will take you to my Sky Drive. In there you will see a Word Document on Naming conventions. Download that and have a good read. This should give you some basics to build on. It there is anything else you want then download that as well. These is a Demo database on Inventory which may help. It is at least worth a look at.

Once you have done that then write your Tables in Access. Set your relationships and do a compact and repair. Please then post your Database so I can have a look and see where we go to from there.

Important. Make sure what you post is in Access 2003. I and many others do not have a later version.

Hope to hear from you soon.