Referential Integrity problem. Related record is required in tableEmployee?

[ApexData]

Access2000, using a continuous form.

I’m getting a message that say “you cannot add or change a record
because a related record is required in table Employee”.

This occurs in all my combobox fields that have referential integrity
linked to another table. I do not have the field in the table set as
required, and I do not want to require the entry. If the record is
filled out completely and added to the table, you can go back to the
same record and eliminate the data in the fields that have referential
integrity and it saves without complaint.

My problem is that when a New Record is created and I fail to enter
data in the fields that have referential integrity set, I get the
error message. Why?

I simply want to create a NewRecord and not require data to be entered
in the fields that have referential integrity.

[Tom van Stiphout]

On Sun, 6 Jul 2008 15:49:08 -0700 (PDT), "Ap******@gmail.com"
<Ap******@gmail.comwrote:

Perhaps you set a default value in the field's table design? Sometimes
Access sets a default value of 0 for an ID field and the related table
may not have such an entry. Take out those defaults.

-Tom.

>Access2000, using a continuous form.

I’m getting a message that say “you cannot add or change a record
because a related record is required in table Employee”.

This occurs in all my combobox fields that have referential integrity
linked to another table. I do not have the field in the table set as
required, and I do not want to require the entry. If the record is
filled out completely and added to the table, you can go back to the
same record and eliminate the data in the fields that have referential
integrity and it saves without complaint.

My problem is that when a New Record is created and I fail to enter
data in the fields that have referential integrity set, I get the
error message. Why?

I simply want to create a NewRecord and not require data to be entered
in the fields that have referential integrity.

[ApexData]

Thanks Tom

That was the problem.
I would have gone nuts wasting time on that one.


On Jul 6, 8:51*pm, Tom van Stiphout <[e-mail]:

On Sun, 6 Jul 2008 15:49:08 -0700 (PDT), "[e-mail]"

<[e-mail]:

Perhaps you set a default value in the field's table design? Sometimes
Access sets a default value of 0 for an ID field and the related table
may not have such an entry. Take out those defaults.

-Tom.

Access2000, using a continuous form.

I’m getting a message that say “you cannot add or change a record
because a related record is required in table Employee”.

This occurs in all my combobox fields that have referential integrity
linked to another table. *I do not have the field in the table set as

required, and I do not want to require the entry. *If the record is
filled out completely and added to the table, you can go back to the
same record and eliminate the data in the fields that have referential
integrity and it saves without complaint.

My problem is that when a New Record is created and I fail to enter
data in the fields that have referential integrity set, I get the
error message. *Why?

I simply want to create a NewRecord and not require data to be entered
in the fields that have referential integrity.- Hide quoted text -

- Show quoted text -