Query to be editable without distinct

[drunkenneo]

I have a query:

SELECT purchaseOrder.poId,  purchaseOrder.poYear, purchaseOrder.poDate, purchaseOrder.userId,  purchaseOrder.currencyId, purchaseOrder.poSendDate, partnerDetails.name
FROM  purchaseOrder INNER JOIN (orderDetails INNER JOIN partnerDetails ON  orderDetails.partnerDetailsId = partnerDetails.partnerDetailsId) ON  Cstr(Format(purchaseOrder.poId,"00000")) =  Nz(MID(orderDetails.poNo,6,5),"0");

Simple join query gives dup entries also, i need in single entry.
When using Distinct query for the form control source, the record is uneditable, can i get the records without dups.

[JoeM]

Simple join query gives dup entries also, i need in single entry.

Then either your join is not correct (not complete) or you have a one-to-many relationship (or many-to-many) relationship.
If you can correct your join so you have no duplicates, then it might be editable. But using DISTINCT or an Aggregate Query will always make a query uneditable, as it combines records into a single row, so it would have no idea which record to edit (if you try to edit it).

Without seeing what you data looks like in each of your tables and understanding the relationship between the two tables, I don't know if we can help you fix your join.

[NTC]

or another answer is; no one cannot make a distinct query editable. So you have to figure out a work-around. one could be to set up forms/subforms so you can edit the data rather than a join via query. another approach is to write to a temp table, edit the temp table - then write the results back to the regular table. it is situational to your data structure and what you are needing to accomplish.