BINDINGSOURCE.ENDEDIT CAUSES "COLUMN DOES NOT ALLOW NULLS" ERROR

[Cam]

Hello All,

Dev Environment:
Visual Studio 2005 (VB.NET)
SQL Server 2005 database (SP1)

Problem:
I get a "Column does not allow nulls" error when I try to add a new record
using the binding navigator. I click on the Add (Plus) button, I type the
values and hit save. I get the error.

Project:
I created the datasets using the dataset designer. The forms somewhat match
the database relations. In other words, the database was setup to have
parent-child relations. The form I am working on now (and trying to add a
record) is one of the child tables.

The column it does not allow nulls is a foreign key of the child table
(form). It is the PK of the parent. I tried to set the value manually, but
got same error.

Me.POLICYDATASET.POLICYTASKOBJECT.NewPOLICYTASKOBJECTRow.PolicyBaseObjectID_PK = 4

Can I access the table right before the add and set the value manually?

Is there something fundamentally wrong with my process or design?

Please advise.

 

[Cam]

As an MSDN subscriber, it is my understanding that I will receive feedback
within two days. Is there a reason for the non-response?

Please adivse