Editing Primary with Cascading Update Relationship

[danifani]

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??