maheshashish
Registered User.
- Local time
- Today, 17:19
- Joined
- Feb 22, 2017
- Messages
- 20
Dear Members,
I am trying to write a small piece of database, who owns a medical shop. Which is an medicines inventory management database. But when ever I try to pull a query for sales entry via query, I am getting a result which is ultimately unable to edit.
I am working with these tables
"MedicinesEntryT" for entering details about medicine, like name and manufacturer etc.
"PurchaseDetailsT" for entering the variable details about medicine like the expiry date, cost of that batch of medicine etc.
"PurchaseInvoiceT" which stores, the invoice number of purchase and dealer information etc.
Now I am successfully able to have the purchase form with the help of a query that joins the three.
But for making sales entry I have used a query which takes some information from " SalesDetailsT" , "medicinesentryT", "PurchaseDetailsT". Now when I run the query the table is uneditable, kindly help me with this issue. I am attaching the database along.
Thanking you advance
I am trying to write a small piece of database, who owns a medical shop. Which is an medicines inventory management database. But when ever I try to pull a query for sales entry via query, I am getting a result which is ultimately unable to edit.
I am working with these tables
"MedicinesEntryT" for entering details about medicine, like name and manufacturer etc.
"PurchaseDetailsT" for entering the variable details about medicine like the expiry date, cost of that batch of medicine etc.
"PurchaseInvoiceT" which stores, the invoice number of purchase and dealer information etc.
Now I am successfully able to have the purchase form with the help of a query that joins the three.
But for making sales entry I have used a query which takes some information from " SalesDetailsT" , "medicinesentryT", "PurchaseDetailsT". Now when I run the query the table is uneditable, kindly help me with this issue. I am attaching the database along.
Thanking you advance