He is saying (I think) that in order to get the results you're looking for you need to change your second table to say
[ID] [Weight]
1 33
2 22

instead of
[Item] [Weight]
Mixer 33
Mixer 22

Your table 1 and table 2 should then be joined on the ID field

That's correct. You may not care which mixer goes with which ID number but Access cares. And if you're not going to link by a unique field to a unique field or a unique field to a non-unique field then you're going to get "duplicates".

The join you are doing now is many to many. What you want is a one to one or one to many.

That's correct. You may not care which mixer goes with which ID number but Access cares. And if you're not going to link by a unique field to a unique field or a unique field to a non-unique field then you're going to get "duplicates".

The join you are doing now is many to many. What you want is a one to one or one to many.

Thanks for the reply. However, I am not able to link ID and Weight because both or them are unique and don't have any other field to link.

In your table 2, instead of having the Item Name, change it to the Item ID, then you will have something to link the ID to. Again, revisit Rabbit's post where he explains how your tables should be set up. You will need to go into the table design and change the Field Name "Item" to ID and make it the same data type as your ID in Table 1. Table 2 should not have the Item Name (i.e. Mixer) anywhere in it. Once you have made the change to Table 2, then link Table 1 and Table 2 by ID.

There is no way to convert the first table into the second table because the first table is all unique records. A record is considered to be the entire row. Since there is at least one field in that record that is different, it is considered unique. If you follow the other suggestions posted (change your format of Table 2), you will not have a problem.