May 30, 2002 at 1:49 pm
Hi Everyone:
I am trying to add the record to the table, and I got the following error message:
"You can not add or change a record because a relative record is required in table"...Does anyone know what could casue this error? Can anyone please give me some suggestions? Thanks alot
May 30, 2002 at 2:26 pm
Sounds like there is a foreign key being enforced, probably via a trigger.
Andy
May 30, 2002 at 3:22 pm
Thanks Andy!
But if that is the case, what should I do to solve it? Any suggestion?
May 30, 2002 at 3:43 pm
You'll have to figure out which other tables are involved, something like a lookup table that contains states or products or something of that nature and add the missing line first. For example, you're trying to an an order for product XYZ, XYZ will have to be in the products table first.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply