Not surprised. A lot of the time when you create a query with a JOIN it becomes non-updateable. Use a form with a subform.

but the form will also show my orders and not allow me to edit
how can I make it editable?

Your parent form should only be based on the OrderT table, or a query that uses only fields from the OrderT. Your subform would be based on the OrderDetailT or the OrderDetailQ which has only fields from the OrderDetailT on it. You can't join them both together like that and expect to be able to EDIT the records. VIEW them, sure.

I'm actually preparing a TechHelp video on dealing with non updateable recordsets (queries). Look for it in the coming weeks.

Is there a typo in ProductT.PoductID?
Should PoductID be ProductID?

By bringing in the OrderDetail* in the query and then bringing in the unit price from productT will go?
that's how you made it, and it works beautifully!

What lesson and time index do I build this query?

Expert 8
Lesson 2
10:32
thank a million for giving your time!

OK. That helps. It's been so many YEARS since I recorded these classes (7 years in this case) that sometimes I need to go back and review what I did so I can help you. In this case, I'm pulling product info into the order detail info so we can display the product name and calculate pricing. In this case, you SHOULD be able to edit the LEFT side of the query. The OrderDetailT fields should still be editable, but not the right side (the product info). That's normal behavior. Like Alex said, check your spelling, you do have ProductID spelled wrong in your Product Table, but you also have that join in there TWICE, which you shouldn't. That could be causing your problem. Get rid of the "AND" and everything after it.

Oh, and don't get too attached to the way the database is built right now. Remember, this is a TEACHING database. I show you a much better way to manage all of this by the time we get to Expert 22 and we FIX it.

thank you very much

My pleasure.