Editing Primary with Cascading Update Relationship

Hi,

Access Newbie...need some help please

I have a large table of products, and approx 15,000 doors as the 'product type', but within the 'product type' column, half have been entered as 'Door' and half as 'Doors'.

How do I edit them to be the same easily without literally adding an 's' to thousands of records.

I tried to make a table of Product Types then have each of the types as the Primary Key, then edit 'Door' to 'Doors', but of course it wont allow it because I need to have a unique primary key.

Help please??

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save