I am tryig to match records from a query in access to records stored in a table. I have a littel problem which i am trying to solve?

Table1
-manufacturer
-model (primary key)
-picture

Table2
-Deal
-price

Query1
-Model (this is in a query as it has been split from other data using the InStr and left function)
-price

I have created a relationship between the 2 model fields in the query and table in query2:
Which has the following fields:-
-manufacturer
-model
-picture
-price

Then I changed the view to data sheet the message box appeared saying “Invaild procedure call” and all data in the fields is changed to “#Name?”
Can someone please help me out cause I really need to solve this problem ASAP. Or is there another way to match these records.
Thank you; any help will be much appreciated.