I have a table named "parts" and a table named "suppliers" there is a junction table between them that lists all the parts from all the suppliers (potentially).
I've created a query to show the lowest price for a part in our database. When a part exists in the "quote" table I want this query to update the supplier ID and price. I've tried a few different ways of achieving this and I'm stumped.
the record set isn't updatable is the most common error I get. As always, any advice is appreciated.