"New Record" arrow not active in query

[Nilay]

Hello. I run a trading business. My present system allows me to add purchase order from customer, and the invoice that I add allows me to select from dropdown the price of the product as it was input in the PO. PO has a subform 'PO product' and invoice has a subform 'invoice product'. Since I always have to add in the 'invoice product' the price that was added in the 'PO product' for a particular product, I'm trying to fetch the price automatically in the invoice from the PO. This I have already achieved as per the attached query.

My problem is, for some reason this design does not allow me to add product in the invoice. Even the query datasheet view does not have the 'New Record' arrow active. Advise appreciated on how to achive this. Thanks

 

[David R]

Your table relationships do not appear to be well-defined, probably because you're not using primary keys properly. The lines in the top half of a well-constructed query on well-constructed tables should have 1 and ∞ symbols on them.

If this doesn't make sense to you, please post a screenshot of Tools>Relationships.

 

[Nilay]

I guess those symbols appear for tables in relationship view; the attached screenshot is of a query design which also has queries and not tables. I'll be able to attach the relationship view in a few hours. In the mean time if this can help - Invoices table has 'invoice number' as primary key. This table has one to many relationship with Invoice product table (matching fields 'invoice number') which has no primary key. ('Customer - Invoice auto' in the above screenshot). Similar is the structure of 'Customer PO' (PO number is primary key) and 'Customer - PO Product' tables. Thanks

 

[boblarson]

Besides what David pointed out, you can't add anything with this query because, for one, you have calculated fields and that renders the query non-updateable right away.

See here for more on "why is my query read-only."