hello all programmers
i'm failed and i can't solved my problem , i would to create a database for supermarket , they used barcode terminology i created one table for input the item , made another one for sell item , but i have problem i don't no how to organize it , i want when the user write down the barcode get the name and price also write down count after that take the average , i created and this is my project in the attachment , but i don't no how to create the relation ship
i'm failed and i can't solved my problem , i would to create a database for supermarket , they used barcode terminology i created one table for input the item , made another one for sell item , but i have problem i don't no how to organize it , i want when the user write down the barcode get the name and price also write down count after that take the average , i created and this is my project in the attachment , but i don't no how to create the relation ship