PHWinfo - Afficher un message

11/04/2008, 22h15

>Hello;
>My Name is Richard.
>I have set up a small record insertion form which can be used to add
potential clients to a database.
>The form should insert a record into tblLeads. I'm getting the following
error when I submit the form:
>
>Error Type:
>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
>[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record
because a related record is >required in table 'tblLeadData'. Line 115
>
>tblLeads is related to tblLeadData via primary key LeadNo with referential
integrity enabled.
>
>I have double and triple checked my code and can't find out what's wrong. I
have even compared the code to >another form that works just fine and can't
find any differences. Line 115 is not really the error itself, it's just the
>"execute" command which doesn't really a lot finding the problem....

>
>I'm at a loss here, so any is greatly appreciated....
>
>Edited: 04/11/2008 at 04:16:47 PM by webmaster@araye.com

First of all, never edit your posts in these forums to add content. Most
people that can you are using the NNTP side and edits are not propogated
to the nntp servers.

Next, when looking at your relationship (Edit Relationship), what is listed
under Table/Query and what is listed under Related Table/Query. Also, how are
the primary keys being generated for these tables?

11/04/2008, 22h15	#6
bregent Messages: n/a Hébergeur:	Re: Referential Integrity >Hello; >My Name is Richard. >I have set up a small record insertion form which can be used to add potential clients to a database. >The form should insert a record into tblLeads. I'm getting the following error when I submit the form: > >Error Type: >Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) >[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is >required in table 'tblLeadData'. Line 115 > >tblLeads is related to tblLeadData via primary key LeadNo with referential integrity enabled. > >I have double and triple checked my code and can't find out what's wrong. I have even compared the code to >another form that works just fine and can't find any differences. Line 115 is not really the error itself, it's just the >"execute" command which doesn't really a lot finding the problem.... > >I'm at a loss here, so any is greatly appreciated.... > >Edited: 04/11/2008 at 04:16:47 PM by webmaster@araye.com First of all, never edit your posts in these forums to add content. Most people that can you are using the NNTP side and edits are not propogated to the nntp servers. Next, when looking at your relationship (Edit Relationship), what is listed under Table/Query and what is listed under Related Table/Query. Also, how are the primary keys being generated for these tables?