[new]

I am not a big user of Access and I need quick help.

I have a table with 2 columns: tbl_Supplier (SupplierID, SupplierName)

The data for 1st column was obtained via a query (from tbl_Products
which provide SupplierID); the data for the second column was to be
populated manually but at the moment has Null value.

I want to make SupplierID to PK once I removed duplicate records. I
have 77 records now but should be 29.

Any help?