ForeignKeyConstraint problem...

Hot Topic

The RootDesigner Can't work with generic
TableAdapter insert/update/delete generated on a table, but WONT on a view
Maximinze Problem in MDI
custom control hosting in DataGridView Header
Windows Authentication with hosted SQL Server?
Background image resources cause VS error
Changing Parent menu from Child form
How do i draw a line just like VB6 but in .NET ? Any control available..
GDI+ graphics and viewport
Databinding using Visual Studio.NET wizards

Windows Forms

Cinchy Save Question
Making a .net Grid
need to get a transparent object on a picturebox
Commit changes to binding data source without losing focus
SelectedValue DGVComboBoxCell??
net send
FindControl in Windows Forms?
Background image on tabs of form
Tabs with a MDI App?
Microsoft Script Control

ForeignKeyConstraint problem...

Hi,

I'm using a dataset to manage an MS Access db. I create two tables, I fill them with data, and I relate two fields:

Table1:                Table2:
CustomerID         ProductID
(AutoNumber)      (Number)

But when I try to add something to table2, the child, I get this error:
"ForeignKeyConstraint Relation1 requires the child key values (1) to exist in the parent table"

Any help

Thanks

Answer this question

ForeignKeyConstraint problem...

  • Carlos González

    I think you don't have a datarow in datatable1 with a primary key value of 1.
  • ForeignKeyConstraint problem...
Answer this question