The Group table has only 3 entities. Each one is represented in the
categories table once atleast. I am not creating a new GroupID. I simply
need to insert that.
I think one can't use CFUPDATE with tables that have referencial integrity
relationships with other tables...am I right?
Nehal
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 12:19 PM
To: '[EMAIL PROTECTED]'
Subject: RE: MS Access CFUPDATE question
Not quite sure exactly how you are updating the record but what that error
message implies is that you are updating a record in the Categories table
whih changes the Group ID so that no other record in that table has that
group ID. Therefore there is a record in Group which has no corresponding
record in Categories
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 06 September 2000 17:20
To: [EMAIL PROTECTED]
Subject: RE: MS Access CFUPDATE question
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.
----------------------------------------------------------------------------
--
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.
