Question need help to make small database software (1 Viewer)

[clickes2000]

hallo to all , i am happy to be able write my question in this forum .

i plan to make a small database software for my shop wih access but i face some problem and i hope some one can help me .

i will write some dateils about my job
.
i sale buy and products . for example

i want make thress tables
1- first table add new product contains ( categories, product, purchase price,purchase quantity,total .stock available)
2-second customer table ( name , second name , adress ......)
3-third invoice table (categories,product ,sale price,sale quantity ,total)

the question how can i connect this tables together .
i mean when i sale a product (in third table) i want to know how many stock
available in (first table) .i want the fields in first table have same information as third table.

example

i bought 5 phones unit preis 10 dollar total 50 dollar
when i sale this product i will make a invoice 3 phones unit price 20 total 50.

i want at the end know how many stock availbale .

thanks

 

[Uncle Gizmo]

>>> i want to know how many stock available in (first table)<<<

Have a look at Allen Browne's Inventory Control: Quantity on Hand

 

[clickes2000]

thanks for your answer , i read this link but i did not undestand it .

i am not profi in access , please clear the answer for me

i want to know when i make a invoice i want to know how can i select the product from first table and fill the other fields in invoice table to calculate the stock availbale .

thanks

 

[bob fitz]

hallo to all , i am happy to be able write my question in this forum .

i plan to make a small database software for my shop wih access but i face some problem and i hope some one can help me .

i will write some dateils about my job
.
i sale buy and products . for example

i want make thress tables
1- first table add new product contains ( categories, product, purchase price,purchase quantity,total .stock available)
2-second customer table ( name , second name , adress ......)
3-third invoice table (categories,product ,sale price,sale quantity ,total)

the question how can i connect this tables together .
i mean when i sale a product (in third table) i want to know how many stock
available in (first table) .i want the fields in first table have same information as third table.

example

i bought 5 phones unit preis 10 dollar total 50 dollar
when i sale this product i will make a invoice 3 phones unit price 20 total 50.

i want at the end know how many stock availbale .

thanks

I think you will need more than three tables. If you are new to database design and development, then IMHO you face a steep learning curve. Read up on normalization and take a look at some of the database models shown in this link. Those on inventory my be of particular interest: http://www.databaseanswers.org/data_models/

 

[clickes2000]

Thanks for your answer .

i have read these links but i have got no answer for my question
i will be thankfull if some one can clear for me what i must do for my project .

tables
1- store table
2- invoice table

1- i want store my product with these fields ( category , product, purchase price , Unit , stock availbale )
2- then when i sale a produt in invoice form i want to hold the product infomation from store table and only write sale price and unit ,

i have a problem when i make a invoice i dont know how to onnect bot table together

pleasae if my question not clear , then just give me a example how to make this project .

thanks alot

 

[jdraw]

Take a closer look at the Sample and diagram in the link that Tony gave you.
Look at the tables involved.
Good luck.

 

[clickes2000]

thank for all

sorry if i ask too much , i have saw a diagram but i have not understand it .

it will be nice if some one can only tell me how can i make a invoice for one product related in tblInvontery .

for example

i bought 2 Phone ( i enter information about these two phones in product table)
like price , unit , stock .

and when i want sale one of these tow phones with tblInvoice .
i can see how much stock availbale

thnaks

 

[Uncle Gizmo]

>>>it will be nice if some one can only tell me how can i make a invoice for one product related in tblInvontery<<<

Download the microsoft Example database, "Northwind" it's not supposed to be a usable invoicing database but it shows a lot of what you want.