Adding new records to a select query

[Nate Adams]

I am having problems getting my select query to allow me
to add records to it. I made a database to keep track of
inventory. I have a "prototype" system to aid in the
transition and also another system (exact same) that we
are currently using. My current system allows me to add
line items into a query, say for purchase orders, etc.
My prototype does not, the arrow with the aterisk at the
bottom of the query is darkened in. That's the only
difference I can find. How do I fix that? Thanks!

 

[Allen Browne]

There are many reasons a query may not be updatable, e.g.:
- It performs some kind of aggregation, such as a DISTINCT or GROUP BY;
- It combines different queries - UNION;
- The field list (SELECT clause) contains a subquery;
- The joins and field selection mean you are trying to add new records to
the "many" side.