Quote Originally Posted by schoolboy View Post
There are other tables (orders, for example) where Product Name is stored. If you have 125 in one table and 64 in another, you are on a disaster heading...

All field lengths for common data MUST be the same...
I searched them all out and changed them. Every one worked fine. Some were around 105 in length with no problems.