Anyone have an idea why the following error occurs when I use two tables in
MS Access that have one-to-many relationship with referencial integrity
applied. I am trying to update a record in Categories table which has one
column called GroupID. The GroupID comes from Table called Group. I have
established one-to-many relationship between Group -to- Categories. I have
turned off the lookup column (combo box) option and changed it to text box.
I still get this error.
Error Diagnostic Information
ODBC Error Code = 23000 (Integrity constraint violation)
[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record
because a related record is required in table 'Group'.
The error occurred while processing an element with a general identifier of
(CFUPDATE), occupying document position (6:2) to (6:124).
Any suggestions are very welcome
Thanks,
Nehal
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
