unable to edit with results of a query

maheshashish

Registered User.
Local time
Tomorrow, 00:11
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
 

Attachments

I only have 2010 so can't work with the file. In general, I only have forms bound to a single table. Combo boxes can get selections from a different table without the form including that table. Like if I'm choosing a product for a sale, the form would be bound to the sale table but a product combo would get its selections from the products table.
 

Users who are viewing this thread

Back
Top Bottom