|
|
|
#4 (permalink) |
|
Messages: n/a
Hébergeur: |
"JoeyD1978" <webforumsuser@macromedia.com> wrote in message news:ftlil7$djm$1@forums.macromedia.com... > Hello Richard! I am have not unfortunately... ROFLMAO..... :-D -- Patty Ayers | Adobe Community Expert www.WebDevBiz.com Free Articles on the Business of Web Development Web Design Contract, Estimate Request Form, Estimate Worksheet -- |
|
|
|
#6 (permalink) |
|
Messages: n/a
Hébergeur: |
>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? |
|
![]() |
| Outils de la discussion | |
|
|