You cannot add or change a related record in table (1 Viewer)

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:09
Joined
Feb 19, 2002
Messages
42,981
I hope you didn't get hurt by flying debris :)

Pat, you broke the bank.
thank you!

Giving you this particular answer is like putting the bullet in the gun for you. But, since it is something you will run into in the future if you forget to remove the "helpful" 0 default for numeric fields, I thought you needed to know. Now that I've loaded the gun for you, please do not fire it. You should NOT fix the problem by simply removing the 0 default from the FK, you should fix the problem by fixing the schema. That is what is wrong.
 

Users who are viewing this thread

Top Bottom